September 25, 2014 at 5:44 pm
Hi all, I am very new to SSIS. I am trying to create package with following problem.
A folder has following files:
A1.xlsx
A2.xlsx
A3.xlsx
A4.xlsx
A5.xlsx
(A1, A2, A3 .....) are name of vendor. All these vendor has different SFTP address. How can I create a package where A1 goes to A1 SFTP folder, A2 goes to A2 SFTP folder and so on?
I have exactly another problem but with email. Each file is associated with different email. How Can I create that package.
Any help will be greatly appreciated.
Thank you
September 25, 2014 at 10:01 pm
aashish.khn (9/25/2014)
Hi all, I am very new to SSIS. I am trying to create package with following problem.A folder has following files:
A1.xlsx
A2.xlsx
A3.xlsx
A4.xlsx
A5.xlsx
(A1, A2, A3 .....) are name of vendor. All these vendor has different SFTP address. How can I create a package where A1 goes to A1 SFTP folder, A2 goes to A2 SFTP folder and so on?
I have exactly another problem but with email. Each file is associated with different email. How Can I create that package.
Any help will be greatly appreciated.
Thank you
Quick thought, look into Expressions. Using expressions you can modify at runtime, properties like connection strings and email recipients.
😎
September 25, 2014 at 10:29 pm
Yeah I am trying to learn that right now. I was wondering if I can save those address as sql table and call those address in ssis
September 26, 2014 at 12:16 am
aashish.khn (9/25/2014)
Yeah I am trying to learn that right now. I was wondering if I can save those address as sql table and call those address in ssis
That is straight forward, the simplest way is to use ExecuteSQL task for retrieving the values. As an example, use the vendor name as a parameter to get vendor specific values.
😎
Quick suggestion, check out the series Stairway to Integration services here on SSC.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply