Hi All, I have posted a question earlier under the title "package created by another user cannot be deployed by me" Please let me explain it one more time. I have a user who developed a package on his PC which is WINDOWS XP 32 bit. He mailed me the package to deploy it onto the production server. The PROTECTION LEVEL is set to "DO NOT SAVE SENSITIVE". I copied the project onto the PRODUCTION SERVER . Created a new project in BIDS and added the package. The PRODUCTION SERVER is "WINDOWS SERVER 2008 R2 SP1" and it is a 64bit machine. In the configuration properties under the PROJECT PROPERTIES i have set the RUN64bitRuntime to false and executed the package and i'm getting the following error: [Execute SQL Task] Error: Failed to acquire connection "DestinationConnectionOLEDB". Connection may not be configured correctly or you may not have the right permissions on this connection. Can anyone please advice me in the right direction , i have done and tried all the things for the past 4days that were suggested to me in the previous post but with no luck. If anyone can tell me where to look that will be great as well. Thanks

Have you ruled out the possibility that your account actually does not have access to the database you are trying to connect to. Going through the other thread nowhere have you mentioned that you have ensured that your account does have the relevant access permissions.http://btsbee.wordpress.com/

Thanks btsbee i have access to both the source and the destination. I checked using the MS and i have used them as latest as yesterday to run other packages that i created.

Do you have DTC transactions supported in your package?Rajkumar

Thanks Rajkumar can you please tell me what DTC transactions are?

Please go through BOL here Rajkumar

Thanks Raj i tried and still the error persists.

what is the error code?Rajkumar

[Execute SQL Task] Error: Failed to acquire connection "DestinationConnectionOLEDB". Connection may not be configured correctly or you may not have the right permissions on this connection. [Connection manager "DestinationConnectionOLEDB"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'DWReports'.".

Did you update the connection manager all connection information.Right click the connection enter related information servername,authentication details and select the database name finally check the test connection... Thanks CMK..

Yes i tested the connections successfully.

[Connection manager "DestinationConnectionOLEDB"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'DWReports'.". by looking this error message, i believe that username is DWReports., i think this user does not have enough permission to deploy packages on production server. make sure that whether this username has enough privileges to deploy the packages. Good Luck..Regards, Chirag Patel (ETL Engineer)

Hi thinkingeye, Please check what connection you are using for the Execute SQL Task, and then check if the user "DWReports" have permission to execute the query in the related database. For more information about permissions in sql server, please refer to: http://msdn.microsoft.com/en-us/library/ms191291(SQL.100).aspx Thanks, EileenPlease remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.