DTS strangeness

Question

Post reply

DTS strangeness

monquatch

Old Hand

Points: 364
More actions
March 31, 2005 at 6:51 pm

#65840

Hi,
Can someone explain this most unusual occurrence to me:
I'm using DTS to Import my stored procedures from a remote MSSQL Server 7.0 to another one here.
After un-checking the 'Copy All Objects' box, I then click 'Select Objects...' and remove checks from all but 'Show Stored Procedures' box, select all, then check all.
Upon successful transfer, I'll refresh the sp's in EM, and VOILA! there appears a handful of sp objects that were not listed in the Select Objects dialogue box!
What the heck is that!!
TIA to anyone who can explain this,
monquatch

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

Are the ones that are not copied user or system procs?

Shamless self promotion - read my blog http://sirsql.net

monquatch Old Hand Points: 364 More actions · Answer 2

The ones I'm trying to copy are all user procs.

It's very strange, like it's drawing from other source of objects entirely.

Some of the successfully transfered objects are similiarly-named from the source, but some are not even listed in the source and are being transferred.

And then some from the source are not even being transferred!

Yikes!

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 3

Des the account that you are using have access to see all the procs? And have you confirmed that there are no alias entries in the client network utility that would cause you to connect to the wrong server by mistake?

Shamless self promotion - read my blog http://sirsql.net

monquatch Old Hand Points: 364 More actions · Answer 4

>> And have you confirmed that there are no alias entries in the client network utility that would cause you to connect to the wrong server by mistake? <<

I'm not sure how to confirm this. Do you mean alias entries in EM?

Thanks again for the response.

monquatch Old Hand Points: 364 More actions · Answer 5

Thanks again for putting up with my denseness.

In the Client Network Utility, there is one entry for Server Alias Configuration - it has the name of my SQL Server, and a Network Library value of 'DBMSLPCN'.

Is that correct?

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 6

Check that the alias does not point to a different server.

Shamless self promotion - read my blog http://sirsql.net

monquatch Old Hand Points: 364 More actions · Answer 7

It doesn't seem to - there is no reference to another server.

>> Does the account that you are using have access to see all the procs? <<

Do you mean the account here on my local server, or the one used to access the remote server to view procs to copy? Either way, how to determine access rights?