qube09
asked on
SSIS Connection as variable
I am in the process of designing an ssis package that will need to insert ftp'd files into a table.
It would be convenient if I knew of a way to pass the name of the file to the SSIS bulk transfer task as a variable so that it could reflect different file names. IS THAT POSSIBLE?
Right now the sql server is sql 2005 but it will be upgraded to sql 2008 r2.
thanks
It would be convenient if I knew of a way to pass the name of the file to the SSIS bulk transfer task as a variable so that it could reflect different file names. IS THAT POSSIBLE?
Right now the sql server is sql 2005 but it will be upgraded to sql 2008 r2.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER