May 14, 2015 at 8:41 pm
Hi All,
Please help me, I have a questions regarding SSIS Config file.
Last month I have bought SQL server hosting at asphostportal.com. Before that I have a simple SSIS Package, and now I am using three different SQL DB. I want to know should I have to create three different config file to store Username/p.w or
I can create one config file?
Thank You.
May 14, 2015 at 10:45 pm
stephanigracie (5/14/2015)
Hi All,Please help me, I have a questions regarding SSIS Config file.
Last month I have bought SQL server hosting at asphostportal.com. Before that I have a simple SSIS Package, and now I am using three different SQL DB. I want to know should I have to create three different config file to store Username/p.w or
I can create one config file?
Thank You.
Hi,
and welcome to the forum. Guess you are not working on SQL Server 7/2000 as then this would be a DTS question;-)
To answer your question, simplest way if using config files is to create different files for each application of the package as the configs are parsed and loaded prior to the package execution. Otherwise you will have to introduce something like an intermediate configuration handling stage within your package that would hold all config values from the file (or a table), can get messy quite quickly.
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply