I want to set destination table programmaticaly in Transformation Data Task.
Is it posible?
Thanks

I'm seeking help on system backup for DTS packages, and, information on how
to backup or save DTS packages so they can be moved / restored to another
server. (we can save to  individual .dts files but this is longwinded - we're
looking for a batch solution)

I have a DTS package (DTS#1) that has an ActiveX script that compares two
values to determine whether package DTS#2 should be executed or not. Does
anyone have an example of how to execute a package from within an ActiveX
script or is there a better way to handle this?

If I open my DTS pkg in Designer, and then save it as a .bas file to modify
it, how can I bring it back in to DTS "Local Packages" in Enterprise manager?
Thanks.

I have a dts package that reads a text file and enters the data in a table.
There is a global variable which I have to pass the value when
executing the package. Instead of passing a value I want the package to do
everything. All I have to do is ececute the package.

Chaps....
I am facing a problem with DTS 2005 (or actually IS 2005, DTS's "successor")
that I am really not able to resolve as of now.
I have a package that reads a flat file and writes data into a database

I created a simple DTS package to export data of some tables to Excel
file. I want to execute it with dtsrun.exe but it hangs before
complete.
The message is like these( I’m using SQLServer Japanese version so I

New guy here - basic situation is as follows.  Trying to import text
file into SQL Server.  The file is sometimes empty so I want to skip
the attempted copy if the file is empty and move on to the next step.
the procedure I'm attempting is at:

I have created a DTS package for reading data from Excel sheet and copying
them to SQL Server database.  Overall it works fine.  But I have a query
about date conversion and would be thankful if someone can help me with the
same.  Here I go -

Potential newbie question...
I have one package that runs inside another one.  I have noticed that I have
to update which version of the package I am running in the envolping one.
So lets says I make a change and save - it gets a different time stamp.

I have defined a DTS custom task with the following declarations for
the DTS Custom Task class
'Required for CustomTask
Implements DTS.CustomTask

Im Trying To Import Data From Excel File To Table.
This Table Have 2 Fileds Only & They r Both Primary Key & With Relation to
Another Table
But It keeps give me the error that there is a violation in Primary Key

When I am building a sql server task I am not be able to put a global
variable inside a dynamic command.
Look at this:
SET @bcpCommand= 'bcp  ' +  @db +  '' + @table + '  out ' +  @strPath +

I have just created some DTS package wich pump data from Visual FoxPro
database to SQL Server 2000.
Everything works fine when I execute de package on my local machine or any
other machine that aren't servers.

I'm having intermittent problems with a DTS package randomly generating empty
files.  My package is actually split up into 4 packages, due to size, and
each package calls the next package in turn.  The first  2 packages work fine
(no exports) gathering data from an external ...