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