Reading Data Pump Task in DTS without having source and destination environment

Hi Frenz,

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.

asked Oct 12 '11 at 11:27 PM in Default

pvsrinivasrao
174 ● 21 ● 27 ● 27

Why don't you have access to the source? Sensitive data, no longer used, etc? Can you get an old copy of the source?

If you can't get the source, can somebody describe the source to you so you can mock up a fake source? That might make the migration go a bit more smoothly. I think that at some point you will need a "source" of some type to get this done.

Oct 12 '11 at 11:37 PM KenJ

source is senstive a bit so we dont have access to it...but yes thats true source will be given at some point of time....But i am looking for a solution which will alllow me to see the Mapping definition without source :(

Oct 12 '11 at 11:41 PM pvsrinivasrao

Can they get you a sanitized version of the source (maybe with X in place of all characters and 9 in place of all digits). At that point it's just a format file and has nothing to do with the source data... and DTS/SSIS will both be happy.

Oct 12 '11 at 11:51 PM KenJ

Thank you Kenj...but currently no :(..but in the meantime is there a way to read the data pump task...may be thru automation atleast?...

Oct 13 '11 at 12:06 AM pvsrinivasrao

(comments are locked)

1 answer:

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