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

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

The script is exactly the same, but doesn't work as part of a DTS package.
-- **************
-- **************    SETUP TEMP TABLES
-- **************

There is a sql task in a dts package that runs a stored procedure which fails
on a primary key constraint while inserting a duplicate row.
If the package is run from the dts designer, it reports an error and follows
the 'on failure' path.

I'm fairly new to DTS. I'm running a Dts where the source and the destination
are Oracle databases. I need to run some Sql statements to create temporary
tables and proper indexes before doing any more complex stuff. When trying to
run those statements in an Sql Task, it seems ...

I have several DTS packages scheduled as jobs in SQL Server Agent. All the
DTS packages execute flawlessly when run manually. When run through the job
subsystem, the DTS packages execute, but packages in which the final step is
to FTP the results to another server will hang on ...

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 ...

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.

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.

I have a dts pagkage on a development server.  How do I
move it to a production server when linked servers are
disallowed?

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 ...

I'm trying to use DTS to upload data via a query statement. The PK is an
identity column. I tried running the query without saying anything about the
PK, thinking it would supply those values (like MS Access does for me) but it
failed because those were left null. What should I ...

Is it possible to execute a cursor in DTS package?
HOW?
Thanks in advance!!

I received from DTS File and related Excel Sheet from my customer. I could
be able to open the DTS File.
It showd a connection between Excel and OLE DB Data Sources.
Then I treied to run this , it says ' Trasform Data Task:Undefined '

I have set up a loop in DTS which connects to various servers and collects
data from them. I have two parameters which are fed into my transform data
task query from global variables.
EXECUTE uspGetAlertPool @LastRun=?,@ServerID=?