Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Upgrate DTS to SSIS in SQL 2008

Author  Topic 

Liew2020
Starting Member

26 Posts

Posted - 2009-02-22 : 21:43:17
Problem with DTS to SSIS in SQL Server2008 migration.
I am trying to migrate the DTS to SSIS in SQL Server 2008 environment, and schedule the job. I found the following error message in the job history.
"This task does not support native Win64 environment. Please run the package in 32-bit WOW environment instead"

Can anyone help me to understand what does it mean? Can DTS migrate to SSIS in SQL Server 2008 environment?

Thank You.

Regards,
Jimmy Liew

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-22 : 23:25:19
What is included inside the package?
Go to Top of Page

Liew2020
Starting Member

26 Posts

Posted - 2009-02-23 : 00:05:19
sodeep,
it would be difficult for me to describe in detail here on the structure of my DTS package. Besides it is very complicate, it linked with Oracle database and SQL databases.

Anyway, thanks for your reply. I found the answer here (http://support.microsoft.com/kb/934653) and it is working now.

Again thanks everyone.

Regards,
Jimmy Liew
Go to Top of Page
   

- Advertisement -