I created one simple package which transforms data(Table Data) from Execute SQL Task to Flat File Destination.
While creating connection manager for OLEDB I ensured i could reach server by checking "Test Connection", it connected successfully.
Now when i try to execute, i came across this below error:
Source: Start Execute SQL Task
Description: Failed to acquire connection "<Connection Name>". Connection may not be configured correctly or you may not have the right permissions on this connection.
Solution which i found was to change the Debug options Run64BitRunTime to False.(By default, it will be set to TRUE).
How to reach the below screen:
Right Click Package name->Properties->Debugging(Under Configuration Properties)
Please refer the screenshot below:
Error generated has no relation to the solution,but still documenting it here for searching solution in future.
While creating connection manager for OLEDB I ensured i could reach server by checking "Test Connection", it connected successfully.
Now when i try to execute, i came across this below error:
Source: Start Execute SQL Task
Description: Failed to acquire connection "<Connection Name>". Connection may not be configured correctly or you may not have the right permissions on this connection.
Solution which i found was to change the Debug options Run64BitRunTime to False.(By default, it will be set to TRUE).
How to reach the below screen:
Right Click Package name->Properties->Debugging(Under Configuration Properties)
Please refer the screenshot below:
Error generated has no relation to the solution,but still documenting it here for searching solution in future.
No comments:
Post a Comment