|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Update Global Variable from SP Posted by Mike Donnelly at 12/31/2004 2:55:01 PM Is it possable to update a Global variable in another DTS package that is to
run later from a stored procedure that is running in a package now
Thank you...more >>
DTS job hangs when run as a scheduled task Posted by Murray Hunt at 12/30/2004 6:27:27 PM The DTS task imports 5 dBaseIV .dbf files across the network to SQL2000
running on a SBS2003 server. The files are set (by the transform tool)
to delete the old records in the matching SQL table and import the new
records. This DTS was created in a terminal services session on a XP
client using...more >>
DTS.. Flatfile Read..... otrher alternative.... ? Posted by Higgim Batham at 12/30/2004 5:46:27 PM Currently I am loading a table by reading a flat file.
Since I am loading more than 5 million records it is taking some time to
load the data. I am using DTS package to read the data.
Is there any alternative(other than DTs package) to read the data from flat
file and to load the data into the t...more >>
DTS TO READ EXCHANGE INBOX SUBJECT Posted by Alfredo Frugone via SQLMonster.com at 12/30/2004 4:15:23 PM I NEED TO DEVELOP A DTS TO READ SUBJECT FROM ALL MESSAGES FROM A SPECIFIC EXCHANGE INBOX, AND IF POSSIBLE MARK AS READED.
HOW CAN I DO THAT?
THANKS
--
Message posted via http://www.sqlmonster.com...more >>
What files are required to use DTS on a client? Posted by WayneM at 12/30/2004 4:01:02 PM I am trying to use DTS in my VB6 app, but cannot figure out what files are
required for my set up program. DTS in my VB6 works on my machine with SQL
Server, but I want to run it on another comptuer. I am using Install shield
to create a setup program, but when I run the program I get an err...more >>
Executing DTS that connect to Oracle from an ASP page Posted by gca1 NO[at]SPAM yahoo.com at 12/30/2004 4:00:23 PM Hi:
I have a DTS that connect to an Oracle database and transform the data
into SQL Server tables and I'm trying to creat an ASP page in a web
server to run this DTS.
I tested this DTS in my computer through the Enterprise Manager, and
it works fine (I have the Oracle Client installed), but...more >>
Help: I need to move a file from one server to another from a DTS package Posted by jaisholstein NO[at]SPAM gmail.com at 12/30/2004 5:26:39 AM Hi all
I've tried about everything. My problem is that I have this .asp page
that executes a DTS Package, this package gets some data from a table,
saves it into a text file. No problem so far.
Now I would like to move the file from my server to another server =
FAIL!!!
Wher i run the DTS Pa...more >>
Append text file destination Posted by Thom at 12/29/2004 10:23:04 AM Is there a way to set a destination text file to be appened to rather than
overwritten? I have looked through the disconnected properties and cannot
find how to set it to append rather than overwrite....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Open File Dialogue within DTS Package? Posted by DavidM at 12/29/2004 8:24:48 AM Hello, I'm new to DTS and have been learning as much about it as I can. I
have about 20 DTS packages at work that simply reads a .csv file and imports
the data into its own table. The problem is, I'm going to have to change
the path/filename and resave the package each time someone wants to ...more >>
Sample DTS Packages? Posted by DavidM at 12/29/2004 8:15:42 AM Does anyone know of any good DTS sites that have sample DTS packages for
common or specialized use?
I've been to sqldts.com and that seems to be the best site I've found.
Also, anyone have any good books/sites to recommend for coding DTS from VB6?
...more >>
Capturing database size on a schedule and graphing? Posted by DavidM at 12/29/2004 8:14:24 AM I'm wondering if there are any other programmers/DBA's out there that have
lots of databases that they need to routinely monitor its file growth over
time. I'm looking for any VB code or scripts that accomplish this.
We have about 500 SQL Server databases on one of our servers and they exten...more >>
Move DTS Package Posted by anonymous poster at 12/29/2004 6:49:14 AM I have a dts pagkage on a development server. How do I
move it to a production server when linked servers are
disallowed?...more >>
DTS export to text Posted by anonymous poster at 12/29/2004 6:48:18 AM Using a sql server connection to text file transfer, I
want to end each row with a Pipe CHR(124), carriage return
CHR(13), and a line feed CHR(10). How do I do that? I'm
doing the package with the GUI....more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |