Error opening an DTSx package
Hi everyone,
I get this error when I try to open a DTSx package in my machine, can anyone help me ? I've all the dlls that I need ( at least the ones that I think I need ) registred on assembly and in the right places.
Uploaded with ImageShack.us
Thanks a lot for your help
May 21st, 2011 9:03am
It seems that you connection manager has some issue in the connection string or connection between the source and destination server.
my idea is to just delete and recreate connection in connection manager and check the connectivity.
hope this will solve your problemThanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2011 9:40am
First off all thanks for your answer. Is there anyway you might help me doing that ? I'm not sure how can I do it.
Thanks
May 21st, 2011 10:16am
seems that you used a third party connection manager "MORSA" , did you installed it and its dependents on the machine ?http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2011 10:45am
Argh, not really. Can you help me doing that ? Probably need to install it then, 64 bit machine.
May 21st, 2011 10:57am
I don't know how you should install it, this is a third party connection manager, you probably have a setup or some dlls for it. just install them. maybe you have some guidelines and how to install documents.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2011 11:50am
1) I think you are trying to connect to Oracle database. Try connecting to Microsoft OLEDB provider for ORacle and run the package.
Happy to help! Thanks. Regards and good Wishes, Deepak.
May 21st, 2011 2:33pm
You are trying to connect to a Oracle database. You will need to install the Oracle Client software
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
You can also download a more efficient Oracle OLE DB Provider from
http://www.oracle.com/technetwork/database/windows/utilsoft-088126.htmlJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
Free Windows Admin Tool Kit Click here and download it now
May 21st, 2011 9:19pm