Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS Execute Permissons

Status
Not open for further replies.

w33mhz

MIS
May 22, 2007
529
US
I seem to have a permissions issue I believe but I can't figure out what it is. There is no excryption on this, so when I change the config I have to put all the passwords in again. When running under SQL Agent Service account runs fine, but when I run from a proxy account that what appears to have the same permissions I get the following error.

Code: 0xC0047062 Source: Select Data Flow Cube Reader [199] Description: System.Data.OleDb.OleDbException: Unspecified error The following system error occurred: The system cannot find the file specified. . at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.D... The package execution fa... The step failed.

Windows Haiku:

Serious error.
All shortcuts have disappeared.
Screen. Mind. Both are blank.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top