package configuration file issue

I have created a simple package with SQL table to table load. I also created and stored connection information in xml configuration file.

the package protectionlevel is "DontSaveSensitive". While i try to run the package I believe it doesn't pick up the configuration file.. and throws the below error: (but it runs fine with other protectionlevel setting).

 

Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "Server1.Stage.etluser" failed with error code 0xC0202009.

 
pl ignore this post

( i don't know how to delete this post)

Some how it started working once i close and restarted the ide




Answer this question

package configuration file issue

  • package configuration file issue