How Can I define an event sink for a DTS package ?Is something which could
be reached through Data pump task?
Thanks

I'd like to use Data pump task to transfer my source (CSV file) to the
Destination(Table) ,but I'd like during the transformation if any of columns
is null ,the last column of the row which is a falg to be set.How I could
achieve this.

"I need to create a file with static header info (first record), result
set from a query and static trailer info (last record). Here is an
example:
Header Info (Record 1)

I'm using a Data pump task which transorms a CSV file to a Table (Source:CSV
file,Destination:Table) .There are some columns  in the Table which don't
exist in the CSV file.I'd like to update those columns in transforming rows
.IS it possible?

Does a DTS package internally store the last time it was executed?
I'd like to generate a report of those that haven't been executed in over 6
months.

I have a DTS package that has several Process tasks that run batch files.  
These batch files contain a few osql commands where sql scripts are run.  
When I initially boot my machine, with my local sql server, and I try to run
my DTS package the Process tasks fail.  If I then open ...

I have a CSV file which has a line (kind of comment ) in the first row and
the last row ,I'd like to use Datapump to trnasfer its data to a Table but I
don't know how to eliminate those two lines.
Any suggestion?

I have created a DTS package and scheduled to run.  When I execute the DTS package manually it works great.
It deletes all the rows in a SQL server Table and then imports query specific data from a Visual Foxprot Free table and appends to the SQL server Database Table.
The same ...

I have a Table with the following schema:
StudentID  Name Address Score Passed
============================
I'd like to create a DTS package which iterates through all the records in

I have a select script that runs ins a Transform Data Task and saves the results to a flat text file (500 char). I need to be able to save the results without a header(column name). I have to be able to remove the header but see no way of doing it. The Transform Data Task ...

I'm having some trouble debugging the following script i used from
sqldts.com.
----------------------------------------------------------------------------------------
' 246 (DefineTheGVs)

Why isn't there a function to ignore all timestamp fields while copied data
from one database to another? I had to set "ignore" for the timestamp for
over 400 tables !!!

I'm creating a natural key for records that are generated with a dat
and timestamp.
The data and timestamp are in a textfile
To get a unique key the timestamp needs to be combined with a coupl

I have written an ETL application with SQL Server 2000 DTS that, among other
thing, loads sequential files into an ODS database. I have used Data Driven
Query component, with Data Pump Phases turned on, and Microsoft Data Link
Component to insert or update rows in tables.

Please help !
We have a DTS which loads files using FTP to another
server. This will be used by app groups and will be run
via click of button using sp_start_job,