I have 50 DTS (sql 2000) packages i wanted to convert those packages to DTSX(SQl 2012)
1.I have used DTS migration wizard to migrate from dts to dtsx, it was done.
2.In that result im getting Execute dts packages task instead of dataflow task.
3.How do i convert from those tasks to dataflowtask, also i wanted to know what are all the things they have used in DTS packages.
4.If i know the source,transformation,destination then i can able to create new dataflow task.