Wednesday, December 29, 2010

Script Taks or script component error In SSIS 2005

The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated.

for the above error go through the following microsoft support link

http://support.microsoft.com/kb/931593

Tuesday, December 28, 2010

Connect to SSIS service on machine "xxx" failed. Access is denied.

If you are getting the error message like "Connect to SSIS service on machine failed. Access is denied." while accessing the SSIS from remote or virtual machine, go thru the following Microsoft support link to resolve the issue.

http://support.microsoft.com/kb/940232

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

Troubleshooting: SSIS Package Execution Using SQL Server Agent (go thru the following link)
http://msdn.microsoft.com/en-us/library/dd440760.aspx

And also go thru the following link for possible causes of DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error

http://msdn.microsoft.com/en-us/library/cc627376(v=SQL.100).aspx