SSIS for MySQL?

[akalinowski]

i'm used to running MSSQL 2k5 and i use the SSIS to automate importing data from a few data sources into the MSSQL db to then run some websites, i am wanting to convert to MySQL and i can do it except i don't know how to or if there exists an equivalent of SSIS for MySQL it doesn't have to be free, but i do need the ability to have it import from ODBC, Excel, CSV and tab delim txts.

akalinowski

http://www.olivelabs.com

 

[r937]

look up the LOAD DATA command in da manual

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[ingresman]

SSIS is built on the old M$ DTS stuff which would see ODBC sources. I had a quick google and found this

http://www.sqlservercentral.com/Forums/Topic432264-148-1.aspx

which looks interesting, it's about DB2 on AS400 but you should be ablr to apply the generic bit in reply 2.
Alternativly you might be able to set up a server alias in SQLServer which points to the MYSQL tables, so to all intents is a SQLServer database.
I havn't tried this for years but I think I got it to work with Informix, have a look at

http://www.mssqltips.com/tip.asp?tip=1620

I'd be interested to see how you get on.