SSIS Package

• rk07

  SSC Enthusiast

  Points: 156

  More actions

  November 17, 2010 at 8:07 pm

  #147714

  Hi Everyone,

  I am newbie to SSIS and just in learning process.I have problem i have created a ssis package which is moving a text file to a database table(OLDB destination) and that working fine.The problem now is that i want to move the package from one server to another server with an XML config file and anyone me in what steps to follow and what properties to change in the config file to achieve this.

  Thanks a lot!!!!!!!

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 18, 2010 at 12:16 pm

  #1252698

  http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

  (first google result for ssis how to use xml config file)

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP