Problem migrating DTS to SSIS

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.
stathisgotsis [ Mi, 23 Januar 2008 19:18 ] [ ID #1914549 ]
Datenbanken » comp.databases.ms-sqlserver » Problem migrating DTS to SSIS

Vorheriges Thema: Months Between
Nächstes Thema: Help-VB.NET and SQL Server 2005