alezar (7/28/2014)
Hi,I'm working on the conversion of a group of DTS to SSIS and the function of a part of them is to export data from an Oracle database to a Sql Server database using :
Source Oledb connection for ODBC
Destination Oledb provider for Sql Server
Transform Data Task
The migration is generating an Execute DTS 2000 package task that refers to a task of the original DTS (see attachment).
I really can't understand why this simple task is not being converted to a Data Flow task.
Thanks.
Alex.
The mapping between the functionality offered by the DTS datapump task and SSIS's data flow task is not a clean one. Some things can be done in the DTS datapump that cannot be done in a data flow task (they are probably done differently in SSIS).
So I think they decided that data pumps were too hard for the wizard to handle.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.