Output parameters -- sql server dts

Gary
9/13/2005 2:39:17 PM

I have an "Execute SQL Task" that reads from a table like this:
select top 1 company_id,filelocation, filename
from Supplier_Download_File_Locations
where statusid = 0
I have created output parameters for the 3 column names.
I need to create a text file based on the company_id, filelocation and
filename columns. In other words when this executes I need it to create a
text file in the filelocation specified, with the filename specified.

Would someone be so kind as to show me how with an example.
I am new at this.

Thanks

Allan Mitchell
9/13/2005 9:49:29 PM

If you have the values in the Global Variables then you can use the
FileSystemObject to create a text file. What do you want to do with the
text file. Is it that you want to change the destination of a datapump
task to be this new name and location?

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Output parameters