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?

Thank you very much for your help in advance.

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

"Geetha" <gelangov@hotmail.com> wrote in message
news:4b40e20a.0410280621.cfce123@posting.google.co m...
> 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?
>
> Thank you very much for your help in advance.