Problem migrating DTS to SSIS
am 23.01.2008 19:18:10 von stathisgotsisHello 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.