I'd like to know if I could use a SQL task to actually load values into
Global variables, or am I just missing something?  I understand how to use
them as passed in arguments to a task, but is it possible to update them
back?

For each row of a table I'm transforming I want to write the row to table A
and insert a row in table B and put the value of an identity column on table
B into a column on table A.
I can get a lookup to do the insert into table B but try as I may I can't

I have a DTS package that has a connection defined for a certain database
so that I can run an execute sql task  against the database.  I then have
another sql task that runs a stored procedure to attempt to restore to the
same database.  Due to the previous sql task my restore ...

I know you can use sp_enum_dtspackages to list the DTS packages
on a given server, but is there a way to list the individual step names, etc.?
TIA
Cheers,

I want to do the following.
Take a list of files that are located in a table (that is updated from
another stored procedure,) and run it thru a loop that does an import. (They
are excel files.)

I have two databases, one local and one on a server that I access
via VPN.
I need to ocasionally synch the two databases. I am able to enter
data locally when I'm "on the road" and when I return to the office

I need to be able to select which data (specific date) the dts package will
extract from one db to another, pref. using some sort of user input.
(VB.net, Access etc)
Allan

Hello Experts,
I am not good at SQL Server.  Would you do me a favor?
If I use DTS Wizard to import data (both source and destination databases
are located in the same database server) and the destination does not

Here is my problem:
I have an Excel file containing a list of funds. I can open it easily enough
and read the funds.
Now I need to execute a Transformation task for each fund by looping through

I had one server with ip address like 198.176.0.12 and other with 198.176.1.23
I want to tranfer 6 table data from first server to second server through
package.
and both server had same sechema.

I've been googling around and haven't quite found what I need...
I'm trying to DTS some tables from one database (Pervasive 8.50
wrapping Btrieve files) to another (SQL Server 2000), but not
quite directly.  The DTS is looping through a set of tables,

I am about to work on a new project and i need some insight and maybe some
directional advice.
Working on SQL server 2000. Its a chain process im designing, a user submits
data via web(asp) into db. I want some kind of automation that would, say

I have a script that I'm running in SQL Query Analyzer and it returns the
correct information.  When I set up the DTS package, using the same script
(copy & paste), the DTS package is dropping a couple of records.  Based on
other packages I've set up, I don't find any errors and ...

SUB: what is the Equivalent of DTSTransformStat_SkipRow(2000) in 2005
I want to know how to skip a row in sql 2005.
Please let me know if any body have the answer

I have a DTS package containg a Send Mail task, which runs fine when
manually executed. Thanks to some great tip at this site I've managed to
create a shell command, which also fires the package.
What I really want to do is to run this package from a query, which