Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smar
Starting Member
5 Posts |
 Posted - 2011-10-18 : 09:40:20
|
| I am trying to create an SSIS package with ms sql as source and my sql as destination and i have created a ado.net connection on control flow pane and when i try to create a connection on data flow pane i cant find ado.net on data flow pane or either in tools . |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 09:49:14
|
| why should you need ado.net connection. you can use oledb connectors for ms sql and mysql in data flow task.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
smar
Starting Member
5 Posts |
Posted - 2011-10-18 : 10:01:37
|
| hi visakh,i am a bit new to ssis , can you please explain the process a bit further , how can i connect to my sql and look into the tables please |
|
|
|
smar
Starting Member
5 Posts |
Posted - 2011-10-18 : 10:04:39
|
| i am not able to see ado.net odbc connection option , when i use ole db destination in data flow |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
smar
Starting Member
5 Posts |
Posted - 2011-10-18 : 10:42:52
|
| it doesnt say how to assign a table name in mysql database and i cant see it , can you please help |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-18 : 10:50:15
|
| see figure under point 12------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
smar
Starting Member
5 Posts |
Posted - 2011-10-18 : 10:56:38
|
| i will make myself more clear here,my source is oledb uses sql server data my destination is mysql for which i have used recordset and oledb connection and managed to get to the mysql database but i am not able to direct the data to a perticular table , it says 80 rows tranfered but i ahve not specified any destination table but just the destination database |
|
|
|
|
|
|
SSIS 2005 job with mysql as destination