dbTalk Databases Forums  

SSIS - Import into MYSQL

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts SSIS - Import into MYSQL

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS - Import into MYSQL in the microsoft.public.sqlserver.dts forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM





you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
  #12  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM





you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
  #13  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM


you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
  #14  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM


you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
  #15  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM


you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
  #16  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM


you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
  #17  
Old   
doug spencer
 
Posts: n/a

Default RE: SSIS - Import into MYSQL - 03-30-2008 , 10:46 AM


you need to create a flat file connection manager, use the DSN name, and use
the follwowing type string, using the dsn name and mysql pswd:
Dsn=mailserver;uid=webuser

"SpankyATL" wrote:

Quote:
No one has any insight on this?

"SpankyATL" wrote:

I'm having a difficult time trying to set up a Data Flow Task that will
export data into a MYSQL database. After I create the OLD DB Destination and
try to create a new OLD DB Connection Manager and new Data Connection, I
don't see a provider that is appropriate. I do have the MYSQL 3.51 ODBC
Driver installed on my machine. What should I be using?

Thanks!

Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top