views:

161

answers:

1

Getting this error trying to run an SSIS Package on a 64 bit install of SS2K5 Enterprise Edition SP3.

Package was developed using 32 bit BIDS, and deployed successfully to 64 bit SS2K5 Enterprise Edition SP2, and 64 bit SS2K5 Developer Edition SP3.

Have upgraded client tools to SP3 with same result.

Amy ideas?

A: 

This kind of error is caused by non having server binaries when you run dtexec.exe. However you've said it'a an EE install.

So: random guess...

Does it run on a 32 bit server install? You may be missing x64 ODBC components

Remember: an SSIS package is just XML/text data so has no concept of x86/x64...

gbn