DTS to SSIS Migration

  • 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...

  • 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.

  • 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.?

  • 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

    http://www.sqlis.com/26.aspx

  • 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

  • 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!

  • 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

    http://www.dtsxchange.com/dtsxchange_screenshots.asp

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply