I am working on migrating a DTS package which contains a oledb source (but we dont have access to the source), a olebd destination (but we have access to the dest.) and a DATA Pump Task.
In this situation If i want to migrate it to 2008 task is it possible.
I don't know how the mappings are defined as 2000 designer throws errors saying unable to find source.
Is there way to skip valdiation of Source when opening Data Pump Task, so that i can see the mappings and define SSIS package.
If it's as much a bit urgent for the customer as it is for you, they will send you a format file.
If it's not quite so urgent for them and they won't give you a format file, you can go into the DTS menu and select Offline Edit (If I Recall Correctly). That will open a dialog window that has all of the objects in the DTS package. Find your data source object and browse its properties. All the metadata about the mapping of the input file will be in there so you can try to reverse engineer the file and use that for the SSIS source.
answered Oct 13 '11 at 12:07 AM