bagleymj
New Member
Hello,
I've been fighting with this problem for a couple of days now.
I have an SSIS package that uses an ODBC connection to the OpenEdge server as its source. Within MS BIDS it runs perfectly fine. But when I try to run the package using SQL Agent, it says that it has insufficient information to establish the password. I read on this very site that I could get it to retain the password by using a Linked Server to the Progress server as a bridge. I have tried this, but I could not find a way to access that connection within SSIS.
Does anyone have any grand advice regarding this issue? I'm afraid I'm stumped.
Thanks in advance for your tremendous help!
I've been fighting with this problem for a couple of days now.
I have an SSIS package that uses an ODBC connection to the OpenEdge server as its source. Within MS BIDS it runs perfectly fine. But when I try to run the package using SQL Agent, it says that it has insufficient information to establish the password. I read on this very site that I could get it to retain the password by using a Linked Server to the Progress server as a bridge. I have tried this, but I could not find a way to access that connection within SSIS.
Does anyone have any grand advice regarding this issue? I'm afraid I'm stumped.
Thanks in advance for your tremendous help!