sql server (alternate): DTS - help -- sql server (alternate)

DTS - help

gelangov NO[at]SPAM hotmail.com
10/28/2004 7:21:20 AM

sql server (alternate):

Create a table (each time different table) – we have a DTS to do that
-- 1
There is a fixed delimited text file; we need to Import this file into
the created table above and we have another DTS to do that. –2

We want to combine these two DTS into one.

The problem is when the table does not exist it will not show in the
drop down list for DTS 2.

Is there a way we can pass the table name as a variable name from DTS
1 to DTS 2. Only for 2, we need a DTS. For 1, it can be a stored
procedure or anything.

My main question is if there is a way to pass the variable name (table
name) to DTS2?

Re: DTS - help

Dan Guzman
10/30/2004 2:38:07 PM

You can assign the table name to a DTS global variable and then use a
dynamic properties task to set DTS object properties to the global variable
value.

--
Hope this helps.

Dan Guzman
SQL Server MVP

[quoted text, click to view]