January 29, 2012 at 12:40 am
Hey,
is it possible to import a csv file , mapping the colonne, to an Mysql database ?
i found out how to with SSIS 2008, with an ADO destination, but i am using SSIS 2005, and i don' have ADO destination...
is there a solution to do the same with SSIS 2005 ??
thx
January 29, 2012 at 5:12 am
There has to be something on MySQL to push CSV files into the database, that might be strightforward.
But if you need SSIS 2005 to do it there are articles/posts like this one on SSC that can guide you:
Data Flow Destination MySQL
http://www.sqlservercentral.com/Forums/Topic877173-148-1.aspx%5B/url%5D
KR,
Iulian
January 29, 2012 at 6:02 am
Use Export - Import Wizard and select the destination with ‘ODBC providers’ (attaching screenshot). Optionally save the export task as SSIS package, edit it, schedule it and run it.
January 29, 2012 at 4:23 pm
Hy, DEV,
it would be exactly what i want to do, but, i have installed the ODBC .NET Data Provider, and i can see the .net Framework Data Provider for ODBC on th Source selection in the import-export wizard, but it doen't appears in the Destination Wizard.
So, i can read from an ODBC source, but i cannot Write on a database using ODBC...
it would be perfect if i would be able to have the same option as display On your screenshot, but is not....
can you help me to find a solution to have this option available ?
thx
USING SQLSERVER 2005 ,SSIS 2005 and Windows server 2003
January 29, 2012 at 4:38 pm
Moreover, i have the DVD of SQLSERVER 2008, with SSIS 2008, which would give me the possibility to use ADO.NET Destination.
But, i have tried to upgrade SSIS 2005 to SSIS 2008 with the tool section, but this feature is not available.....
i can't clic on the tool : upgrade Intregration SERVICE
I can see : -System Configuration Checker
- Installed SQL SERVER features discovery report
-Upgrade Integration Services Packages
See the attached file.
thx
January 29, 2012 at 8:39 pm
At the end, i have took an other option :
i 've done as explained here :
http://www.windows-tech.info/15/b99bb4046f3f0c09.php
and everything goes right.
i will work on the upgrade to MSSQL 2008 in a couple of week, but at the moment, this solution works fine.
despite i 've change solution, have you a solution for upgrade SSIS 2008 ?
thx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply