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

pvsrinivasrao gravatar image

174 26 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, 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

KenJ gravatar image

20.3k 1 4 12

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 2005 times

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