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.

more ▼

asked Oct 12, 2011 at 11:27 PM in Default

avatar image

174 26 27 30

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, 2011 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, 2011 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, 2011 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, 2011 at 12:06 AM pvsrinivasrao
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Oct 13, 2011 at 12:07 AM

avatar image

24.4k 3 10 19

Thats perfect!!!

Oct 13, 2011 at 12:37 AM pvsrinivasrao

Kenj do u knw where we can access DTS documentation. (SQL Server 2000)

Oct 13, 2011 at 01:22 AM pvsrinivasrao

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

Oct 13, 2011 at 08:15 AM KenJ
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 12, 2011 at 11:27 PM

Seen: 2906 times

Last Updated: Oct 13, 2011 at 07:04 AM

Copyright 2016 Redgate Software. Privacy Policy