fail execute package with Execute Package utility
hi, i have a package that the source package file run successfull when i execute with ssis(in visual studio),but when i run this package with Integration Service in sql(Execute Package utility) i receive this error: failed to acquire connection"co.co" .connection may not configured correctly or you may not have the right permition on this connection and in this package ,i have 2 execute sql task that first task connect to linkserver to oracle for run a store procedure and next task conect to oracle with connection "co.co" and next task is a Analysis Services Processing Task that connect to Analysis service project... have any suggestion with solve this error?
July 20th, 2011 3:43am

Hi, Are you running the package under the same security context when you use DTExec? Are you using a package configuration that may be incorrect?Peter Carter http://sqlserverdownanddirty.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2011 3:49am

what is the Protection Level of package? try with EncryptSensitiveWithPasswordhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com
July 20th, 2011 3:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics