Problem migrating DTS to SSIS

• stathisgotsis

  SSC Enthusiast

  Points: 105

  More actions

  February 3, 2008 at 5:12 am

  #123469

  Hello everyone,

  I imported a DTS package from SQL2000 to SQL2005. The problem is

  the package fails during validation. That happens because some temp

  tables are created at some point of the package and the validation

  reaches a point where those tables are used. While the execution of

  the package is successful at SQL2000 (where temp tables are created

  during runtime and used afterwards), validation fails at the point

  where these tables are used because they wrere not created in the

  first place.

  Is there any solution to this problem?

  Thank you.

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  February 4, 2008 at 10:17 am

  #774820

  Try going into those component properties and selecting 'Delay Validation'.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE:
  
  

• Johan Bijnens

  SSC Guru

  Points: 135364

  More actions

  February 7, 2008 at 2:43 am

  #775913

  you need to set you destination connection parameter

  "retainsameconnection" to true (false by default) to be able to use

  #tmp tables !

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me