Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

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
0
qube09
Asked:
qube09
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
First Download all files to Folder using FTP tasks "Receive files" operation.

Then take Foreach loop and use File enumerator to iterate files from the (Download) folder.

Take each file path in variable.

Use appropriate task to data data to sql. if file structure is same then you can use Dataflow task if different then use bulk insert as well.

Foreach task
0
 
qube09Author Commented:
yes I agree that that is the potential path but there are no specifics.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now