Hi i am very new to DTS but have a little experience of Stored Procs... so sorry if i am asking a silly question.
Esentially i need to execute a stored procedure from within a DTS pacakge the Stored Procedure will return a Table_Name.
Within my DTS Package I want to store this Table_Name as a Global Varaible so I can use it in a SQL Statement. I will then export the results of the sql as a csv file.
Now I am ok getting DTS ro run a SQL statement and export the results to a csv file.. + running a SP is ok, but how do I assign the returned value from a SP to a global variable and then use that global variable in my sql statement in the FROM clause.
Any help will be grately received i know this is possible!
Esentially i need to execute a stored procedure from within a DTS pacakge the Stored Procedure will return a Table_Name.
Within my DTS Package I want to store this Table_Name as a Global Varaible so I can use it in a SQL Statement. I will then export the results of the sql as a csv file.
Now I am ok getting DTS ro run a SQL statement and export the results to a csv file.. + running a SP is ok, but how do I assign the returned value from a SP to a global variable and then use that global variable in my sql statement in the FROM clause.
Any help will be grately received i know this is possible!