Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSIS mysql to mssql Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 2:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 4:09 AM
Points: 8, Visits: 52
I created in
C:\Windows\SysWOW64\odbcad32.exe
and
I instaled mysql-connector-odbc-5.1.12-win32
Post #1496752
Posted Friday, September 20, 2013 3:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:05 AM
Points: 285, Visits: 334
Hi
It looks you have 32-bit odbc drivers , try to run your package from cmd using :

<drive>:\ Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe /F <your package>
and let us know the status.

Br.
Mike
Post #1496755
Posted Friday, September 20, 2013 4:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 4:09 AM
Points: 8, Visits: 52
Sorry I have 64

I ran in cmp and I have error.

Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Nieprawidłowy klucz do użycia w podanym stanie.". You may not be authorized to access this information. This error occurs when there is a cryptograph
Verify that the correct key is available.
Post #1496776
Posted Friday, September 20, 2013 4:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:05 AM
Points: 285, Visits: 334
Hi

I'm guessing that your native SQL connections are 'trusted'
,so please set Protection Level for this package to "DontSaveSensitive" and try again run in 32-bit mode:

<drive>:\ Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe /F <your package>

and then in 64-bit mode:

<drive>:\ Program Files\Microsoft SQL Server\110\DTS\Binn\DTExec.exe /F <your package>

Br.
Mike
Post #1496799
Posted Monday, September 23, 2013 12:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 4:09 AM
Points: 8, Visits: 52
Problem is the end.
I change ADO NET -> MySQL Data provider to ADO NET ->Odbc Data Provider and I don't used user DSN but I connect direct use connect string "Driver={MySQL ODBC 5.1 Driver};server=<myServer>;uid=<user>;port=3306;database=<NameDataBase>;user=<user>;option=3"

Thank you for help
Post #1497273
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse