You might encounter this problem, while you debug or execute the SSIS package in SQL Server Business Intelligence Development Studio.

No need to worry first of all, it is a simple fix!

Firstly, while you debug, change the Run64BitRuntime property to False in the SSIS Property Pages. Click Ok and try executing the script.


But you may again encounter, the error message, while you add this SSIS as a Job in the SQL Server Agent. The process to fix the problem is mentioned below.

After you deploy the package in SQL Sever, you need to change the driver type for the SQL Server Step to 32/64 bit driver.Screeshot



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s