May 19, 2008 at 2:54 pm
i am trying to migrate my dts to SSIS. my current DTS has dynamic properties, which connects to the ini file which has user name password and servername.
i know it won't migrate into SSIS, so i am thinking about best way should i do Xml or SSIS Configuration table.
can anyone help me on this one...
May 20, 2008 at 1:26 pm
I think the best way of doing it is with XML and making like a "installer" for your packages, so when you install this packages all the properties you decided to be configured will be asked. Is this kinda what you wanna do? :ermm: it just hit me that I may be misunderstanding your question lol
Hope I could help in any way.
May 21, 2008 at 8:27 am
xml file might be a option but how about creating a ssis configuration table, so that my package can go into table and takes the variables itself...
do u think that is doable.?
May 21, 2008 at 9:04 am
For SSIS to go into a table to get configuration data, it needs to connect to the server hosting that table. That means you need at least a small subset of the config to be outside of the table.
There are many good articles available about the various runtime package config options
eg:
http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm
May 21, 2008 at 9:07 am
Instead of building your own, you could use package configuration files to dynamically configure packages at runtime. Package configuration is a new feature of SSIS and can be generated by using the Package Configuration Organizer wizard in Business Intelligence Development Studio (BIDS).
You can create a configuration file for development, testing, and production and you won't have to change properties in the package as it moves between environments. See "Creating Package Configurations" in BOL.
Greg
May 21, 2008 at 11:11 am
Greg Charles (5/21/2008)
Instead of building your own, you could use package configuration files to dynamically configure packages at runtime. Package configuration is a new feature of SSIS and can be generated by using the Package Configuration Organizer wizard in Business Intelligence Development Studio (BIDS).You can create a configuration file for development, testing, and production and you won't have to change properties in the package as it moves between environments. See "Creating Package Configurations" in BOL.
Yeah I totally agree with Greg, that is the best thing you could do. I mean using package configuration files to dynamically configure your packages at runtime 😉 Good luck!
July 1, 2008 at 2:27 pm
Dynamic Properties Can be replaced with Script Task or Expressions. You can also Config file but it may not be exact same result some times because they are always loaded when package starts... and dynamic properties are set at certain steps in the package.
If you are curious to know more about automated solution of DTS to SSIS migration then dont miss product called DTS xChange
Homepage
http://www.dtsxchange.com/[/url]
Comparison with MS Wizard
http://dtsxchange.com/DTSxChange-vs-MSWizard.asp
Screenshots
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply