By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,947 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,947 IT Pros & Developers. It's quick & easy.

Problem migrating DTS to SSIS

P: n/a
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.
Jan 23 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.