Fully Qualified Names data transformation in DTS

• David Belof

  Newbie

  Points: 1

  More actions

  July 21, 2005 at 10:27 am

  #102655

  I want to remove the fully qualified names within my data transformation within my DTS package.  I will be moving this dts between dev, test, UAT, and production environments, and I do not want to go through every transformation and re-id the tables (as they have the database name listed before every table, and the database names change in each environment); I want to make one change in my database connection, that will then be reflected in all my transformations.

  Thoughts?

• dm

  Ten Centuries

  Points: 1135

  More actions

  July 21, 2005 at 10:55 am

  #576159

  There are many different ways to make a package portable.  Here is one:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=99&messageid=8511

  And another:

  http://sqlservercentral.com/cs/blogs/phil_cart/archive/2005/07/19/59.aspx

  I've used ActiveX tasks to set Server and Database Connection information based on Dev, QA, or Production Environments.

  Diane