Any clues why this would occur? Also, in case you were curious, I am on sql server 2000 with service pack 4
Quote:
Originally Posted by catstevens
I'm trying to build a DTS package that will copy data from one server to another, and I'm using the latest teradata ODBC driver to connect to teradata. The problem is when i setup the dts package - DTS just sits there and hangs when i try to make a new data pump task.
Any clues why this would occur? Also, in case you were curious, I am on sql server 2000 with service pack 4
Have you connected to your data source before doing this?|||hi,
i kind of figured out what was wrong so in case anyone googles this - dts attempts to look at every table in the data source for every database. because the source connection i was trying to pump from had so many tables it hung for a good 3 minutes before the properties window opened.
it sped up a little when I performed the editing on the server itself (as opposed to a workstation using enterprise manager).
thanks|||
Quote:
Originally Posted by catstevens
hi,
i kind of figured out what was wrong so in case anyone googles this - dts attempts to look at every table in the data source for every database. because the source connection i was trying to pump from had so many tables it hung for a good 3 minutes before the properties window opened.
it sped up a little when I performed the editing on the server itself (as opposed to a workstation using enterprise manager).
thanks
Hey dude,
What do you mean by editing on the server. I am a newbie to the data world and am trying to do the same ..extracting the data from TeraData to SQL Server. Its hanging and I was never able to get this done.
Can you please help me here...
THanks,
Rahul
No comments:
Post a Comment