June 10, 2008 at 6:40 am
Hi I am new to SSIS implementation and need your help.
My task is to copy data from files in an FTP server to sql database. For this i want to use FTP task.
I found a few articles of how to use a FTP task. My question is ... can i store the system name, login and password in a configuration file instead of giving them directly. Because if the FTP source system is changed, then i need to open the package and do the modifications.
If that cannot be accomplised, i need to split my package into 2 and go ahead so that i will not disturb the remaining tasks.
Any suggestion or work arounds are highly appreciated. Thanks in advance.
June 10, 2008 at 8:09 am
For sure you can...
Basically anything you configure on your SSIS palette can be stored in a configuration.
Click on SSIS>Configurations, and have a look at your options.
If you need a little more detailed walkthrough, please post.
Good luck!
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply