Posted by stathisgotsis@hotmail.com on 01/23/08 18:18

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.

• Next in forum: DELETE ... NOT query does not delete all that I expected
• Prev in forum: Re: NULL values in a SELECT in another SELECT
• Thread view: Problem migrating DTS to SSIS

[Reply to this message]