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
Gary

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

"Gary" <Gary (AT) discussions (DOT) microsoft.com> wrote