SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS mysql to mssql


SSIS mysql to mssql

Author
Message
ddebski
ddebski
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 63
I make same package ssis in visual studio 2010.
I load data from mysql to mssql 2012.
I created ADO.NET source(connect with mysql) and OLE DB (connect with mssql).
When I started debugging in visual studio date load from mysql to mssql without problems.
After I loaded ssis in mssql and make job in sql agnet.
When I start job I have "error ADO NET Source has failed to acquire to the connection with the following error message "Could not create a managed connection manager".

What should I do?
michal.lisinski
michal.lisinski
SSC Eights!
SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)

Group: General Forum Members
Points: 986 Visits: 1105
Hi
Did you set Run64BitRuntime as false?

Br.
Mike
Alvin Ramard
Alvin Ramard
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4187 Visits: 11639
First thing that comes to mind is that when you were debugging the package, you were running it from your computer. Then you tried running it from the server.

Does the server have the required driver?



Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27625 Visits: 13268
michal.lisinski (9/18/2013)
Hi
Did you set Run64BitRuntime as false?

Br.
Mike


This is a design time setting only and doesn't affect the execution of a package on the server.

However, you might be on the right track: it's possible the server is 64-bit and hasn't the 64-bit providers installed, something Alvin was also guessing at.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
ddebski
ddebski
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 63
Ok I see problem.
First I ran package on my computer and I didn't problem.
When I ran on other server I had problem.
I thint than problem is with ODBC on server but I don't find mistake.
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27625 Visits: 13268
Is the ODBC 32 or 64-bit?


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
michal.lisinski
michal.lisinski
SSC Eights!
SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)

Group: General Forum Members
Points: 986 Visits: 1105
Hi Koen

I've already met with that problem. Package tested on wkst with 32bit odbc and moved to 64bit environment, of course there were installed 32-bit odbc on the server. It started in 64bit mode first but unfortunately without success.

I'm not sure if that's it, but Imho it's a good thing to check first.

Br.
Mike
ddebski
ddebski
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 63
I tested on win7 64 and after i try run on win 2008 64. On win7 is ok but on win 2008 is problem.
On win 7 I have mysql odbc 5.1 driver. On win 2008 I have mysql odbc 5.2 ansi driver. In win 2008 I create DSN user and I tryed connect with datebase and I didn't problem. Why doesn't package run?
ddebski
ddebski
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 63
I changed in ADO NET provider from mysql data provider on odbc data provider.
Next I created DSN user and I ran test. Connect test DSN user the end succes.
I ran package on visual studio and succes but when I try run on mmsm I have error [im002].
michal.lisinski
michal.lisinski
SSC Eights!
SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)SSC Eights! (986 reputation)

Group: General Forum Members
Points: 986 Visits: 1105
Hi
Did you configure new DSN from C:\Windows\System32\odbcad32.exe or C:\Windows\SysWow64\odbcad32.exe?
And could you please answer Koen's question.

Regards
Mike
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search