Use a OLE DB ConnectionManager.
What is yourmigrated package using?
Why is it illegal? What error message do you get?
-Jamie
|||When you double click on the connection you get the error:
The specified provider is not supported. Please choose different provider in connection manager.
When you do get in it is all greyed out and when you test connection you get the follow error in this screen shot:
http://216.247.79.34/public/ssiserror.jpg
Here is the DTS 2000 input setup for the access file using DSN
http://216.247.79.34/public/ssiserror1.jpg
|||Try using the "Native OLE DB\microsoft jet 4.0 OLE DB Provider" Provider.
I've just installed SSIS on a clean O/S and this is working fine.
-Jamie
No comments:
Post a Comment