question

pvsrinivasrao avatar image
pvsrinivasrao asked

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.
sql-server-2008ssismigrationupgradedts
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
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.
0 Likes 0 ·
pvsrinivasrao avatar image pvsrinivasrao commented ·
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 :(
0 Likes 0 ·
KenJ avatar image KenJ commented ·
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.
0 Likes 0 ·
pvsrinivasrao avatar image pvsrinivasrao commented ·
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?...
0 Likes 0 ·

1 Answer

·
KenJ avatar image
KenJ answered
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.
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pvsrinivasrao avatar image pvsrinivasrao commented ·
Thats perfect!!!
0 Likes 0 ·
pvsrinivasrao avatar image pvsrinivasrao commented ·
Kenj do u knw where we can access DTS documentation. (SQL Server 2000)
0 Likes 0 ·
KenJ avatar image KenJ commented ·
MSDN Books Online (it takes some digging, so I usually use google instead) - http://msdn.microsoft.com/en-us/library/aa298646(v=SQL.80).aspx
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.