I'd like to have a global variable which is reset on every row in my data
pump task.I tried to reset my global variable in the first first field of my
column mapping in Data pump task ,but to my surprise there is no order for
columns to be transfered in each record.

Is i possible to call an insert stored procedure while I am transforming
records using Data pump task (in my activex).According to this example ,I
should be able to do it ,but It dosen't work for me.
http://www.databasejournal.com/features/mssql/article.php/1459171

I am using a simple lookup liske this :
SELECT     COUNT(USERID) AS countID
FROM         dbo.user
WHERE     (IS_ACTIVE = 'Y') AND (USERID= ?)

I'm transfering a CSV file into a Table .
In Table I have a field called record number which I'd like to insert the
record number of the equivalent record in the CSV file.How can I simulate
it?

Here is an article about restoring DTS Connection passwords:
http://jimmers.russia.webmatrixhosting.net/dtspackage2.aspx
This maybe useful when you have only DTS package and need to get all
information from it.

I have this script in my datapump task ,I'd like to update a field in the
current row when an error happens ,,
Function Main()
IF DTSSource("Col001") <> "C1" THEN

I have three tables like this.
Table1:
studentID  IsntID      FN      LN
======  =====    ===     ===

How can I use DTS to load 103 spreadsheets of varying names?  The names are
close but vary by date.  Inside the spreadsheet I can pretty much count on
the columns staying the same but sometimes they do change.  Normally I just
use MS Access import for the import and do some clean ...

The contract administration department in my organization is evaluating
a software package that uses SQL Server 2000.  They would like to
import data from the mainframe to this database.  Essentially, they
would press a function key which would create a flat file containing

             I have written a DTS package that ends with an ActiveX Script
step to rename the Access database file that the package imports from.
Executing each step works fine but when I run the whole package, the final
step fails, presumably because the Access database is ...

              can anyone tell me which connection is closed when you check
the Close Connection on Completion option of a datapump workflow?  Is it
source, destination or both?
Regards,

My apologies for cross-posting, but I'm not sure which newsgroup this belongs in.
I am attempting to execute a DTS package from Visual Basic, and I'm encountering a problem.
In a nutshell, how does a low-level user (from a security standpoint) execute a DTS package?
' here's the ...

I know very little about DTS (yet). I need to export to a text file. Each
SQL 2000 record needs to create multiple lines in the text file. What's the
best way to do this? I'm wondering if I need to use the FileSystemObject, or
if I can do this in a more direct manner.

I'm trying to find out how to edit/View my query that I created when I
created my DTS package.  When I go to Enterprise Manager and click on Data
Transformation Services, Local Packages and then click on my DTS Package it
takes me to the DTS Gui interface I can see my package ...

I have a single SQL Server 2000 installed on my server but there are more
than one users that building their own DTS packages on that machine. Is there
any way that I can make a separate repository of the DTS Packages for each
user/database