I have to create a DTS package that will import a file into my database.
This file can come from a Unix machine or a DOS machine so the row
delimiter will be either {LF} or {CR}{LF}.  I know I can write my package
to handle either of these row delimiters, but can I write it so that ...

I have added another Destination to my DTS package (it is a different table
in the same database).  Now the DTS package isn't working as expected.
It now loops through the query, picks up the ExcelLink and executes the 1st
transform, then loops back, when the loop is finished, ...

I have a package that starts and ends with ActiveX tasks.  The first task
locates a file and then enables the following step:
   Set stpStart = pkg.Steps("DTSStep_DTSDataPumpTask_1")
   stpStart.DisableStep=False

I have a large text file which has columns name in first row (column
separated by "|" char).  The file contains 125,000 records when I use DTS to
import this file the DTS hangs after importing 61000 rows (as per progress
bar showing). Is there is any limitation on maximum number ...

Created a DTS package and executed it successfully from a VB .Net program via
the DTS Package Object.  I then added a third party custom task to the
package via the DTS designer.  I can still run the package successfully from
Enterprise Manager or DTSRun.  However, running it in ...

I'm trying to create a DTS package that transfers a database (using Transfer
Databases Task) from a remote SQL server to my local machine (the database
doesn't exist on my local machine before the transfer), then runs a SQL
script against the new local database using the Execute ...

I have an issue where I cannot use input parameters in an Execute SQL task. I
can write any query which will hold values or other variables eg @LogRecID =
23 or @LogRecID = @AnotherVariable, and when I hit the parse button the
syntax is fine. Indeed I can cut and paste it into ...

I'm using a Dynamic property to change my pump Task connection based on a
global variable.The global variable specifies which database I'd like to use
my DTS in.DestinationObjectName is something like
[DatabaseName].[dbo].[TableName]. I don;t know how to change this portion

I have been given the Administrator Role (in our server).In our server there
are two databases.I'm in Public role for both databses .My DTS package works
in one database in other database it gives me this error :
Step 'DTSStep_DTSDataPumpTask_1' failed

After I restore a msdb database from a server to another, I like to modify my
DTS
with my user MYUSER :
- I can create a new DTS,

Hi to everybody!
On using the Build Query option from the Data Transformation task, I' ve
realized that the update query only allows updating a field with a scalar
value.

I'm creating a package to import a set of
5 very large text tables, they all have the same
structure (515 fileds). I would like to
do it all in one single package running parallel

I have a number of packages that I need to move from one server to another.
However, I also need to add owner and user passwords to each package. I am
trying to find out if I can do this from the back end by select the records
(DTS packages) and inserting them into the ...

Two weeks ago we migrated our database to another server including our
DTS packages.  We went in and replaced the Server connections with the
new server name where necessary including within Active X scripts where
a connection is declared.  The problem is, now all of the packages I

is there a way to trace the DTS package. We use profiler to profile/trace
the sql database. but is there a way to trace the dts package, each step of
it.
We have active x script and i need to trace thru each step as it executes.