Hi , I am New For SSIS Package.When Executing with SSIS Package I Get these Errors,Can Any One Provide this Solution.

1) Source Connecting with ADO NET with MySql Server

2)Destination is SqlServer Destination.

3)And Run(Executive) this Package, I  get these Error.

Can Any one Provide the Solution.

 [ADO NET Source [199]] Error: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException: Could not create a managed connection manager.
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

AND

[SSIS.Pipeline] Error: component "ADO NET Source" (199) failed validation and returned error code 0x80131500.

Hi ,

It seems date type issue .

Please share your Source Query.
If you are using table in Source then share Columns name and Data type of source table.

Or it might be Connection issue for Source .
for MySQL connection you can also use ODBC connection

http://techequation.com/import-export-between-mysql-and-sql-using-ssis/

Please check whether your project is 64 bit or 32 bit from project properties. Make Run64BitRuntime as false if it is set as true and then try executing your package.

Hi ,

As per below link where same error is describe and resolve using 64 bit as false;

So you can set Solution->Properties->Debugging->RUN64BitRunTime =FALSE
http://blogs.msdn.com/b/mattm/archive/2008/03/04/connecting-to-mysql-from-ssis.aspx


thanks

RUN64BitRunTime only determines how package gets executed ie 32 bit or 64 bit inside SSIS Designer (BIDS/SSDT) . SO if its in local that you're getting this error then you can try this

However if you're getting this in a job then this setting has no relevance there. In the job you need to configure this as below

Go to Job Step properties for step which executes SSIS package

Go to Execution Options tab and set Use 32 bit runtime checkbox to make it run in 32 bit if you want (default is 64 bit ie the checkbox would be unchecked)

I Get A Solution for My Problem.

http://forums.mysql.com/read.php?60,585162,585162

2)You need to open the using windows 32 ODBC admin tool. DO NOT open the regular ODBC admin, in control panel. Open the ODBC admin located here: c:\Windows\SysWOW64\odbcad32.exe. If you use the default ODBC adminit will not work. Additionally you must create a User DSN - NOT a System DSN. Otherwise it will not show up in SSIS 

NOTE: the screens look the same so you will have no way of knowing whether you are in 32 BIT ODBC Admin tool or not. 

Thanku.

• Edited by PolamMadhavaReddy 2 hours 15 minutes ago
• Marked as answer by PolamMadhavaReddy 2 hours 13 minutes ago