Integrating CRM 2011 using SQL Integration Services (SSIS)

Question Status

Mary GH asked a question on 27 Apr 2012 7:35 AM

Hi, I try to integrate CRM 2011 with SQL database using SSIS. For this I use the folowing link:  , but in the package processing:

 I get an error:



Please help me to solve this problem.


Gus Gonzalez responded on 30 Apr 2012 12:22 PM

Could you paste the entire code in here?

If not, please upload to and place the url here.


Javier Ramos responded on 29 May 2012 4:56 PM

I have the same problem. Can you solve ???

Rok Zupancic responded on 30 May 2012 4:51 AM

Can you tell us a bit more about your setup where are SSIS services running where is the SQL server, how is your crm configured (clamims/IFD)...

Javier Ramos responded on 30 May 2012 1:47 PM

Hi Rok,

The SSIS server is 2008 R2 and authenticated as the blog says, the CRM is installed on-premise mode, and i work on server with Windows 2008 R2.

I await your comments. Thanks.


Rok Zupancic responded on 31 May 2012 6:18 AM

Can you post full error message as well.

Javier Ramos responded on 21 Jun 2012 8:12 PM

I cannot by use VS 2010 and SQL Server 2012 to resolve. Thanks a lot. Regards.

riyaz_sst responded on 18 Dec 2013 10:04 PM

Dear Javier Ramos,

We are also facing the same issue, kindly let us know if you have found any solution for this.


Mohammad Riyazuddin.

CRM Consultant.