Experimenting with the dts package and some hints an advice from fellow DBA's, the problem of data transfer has been temporarily been resolved.
It may not be the most efficient way..but...hey..it gets the work done..
I had to transfer data from a MS SQL table to MYSQL table.
Achieved in the following way:
1) have a drop table execute sql task (which drops the mysql table)
2) have a create table execute sql task (which creates the mysql table again)
3) have a insert execute sql task (to insert a row of test data in mysql table)
[Naturally a MSSQL connection with data pump to MYSQL connection]
when data is transferred from MSSQL table to MYSQL table
4) have a delete execute sql task ( to delete the test data row)
Like I said..its not efficient...especially if you have very large data tables...
but for the time being thats the workaround I have found.
You can either use queries in your data pump to transfer the data or directly from source table(MSSQL) to destination table(MYSQL) if both are same.
If anyone comes up with a better idea or better workaround technique,
Please contact me on
murtazam@spotlight.com.au or post the technique on this forum.
Thank You