Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Dts

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-18 : 09:42:00
Sira writes "If the dts gives errors like some column is invalid when you are dropping and recreating the error...Is that a bug? And where can you check for error explanation as to what happened?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-18 : 10:05:26
It's difficult to answer your question the way you've phrased it. If you are doing something in your DTS package or code, and that action interferes with or prevents DTS from doing its job, then reporting an error is NOT a bug. You'll have to describe EXACTLY what you are doing in order for us to provide more help.

If you run a DTS package and it reports an error, you can double-click on the step in the execution window and it will give you a more complete error description.

Go to Top of Page

Sira
Starting Member

5 Posts

Posted - 2002-04-24 : 14:48:58
i was running a simple dts task and not a package. The error said something like some invalid column. Where can I find out what has changed in that database since the error is not clear?

Go to Top of Page

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-04-24 : 15:59:30
Even one task is run inside of a DTS Package. I you open the properties of your task (assuming data pump task) you and click on the different tabs you should be able to see what's not linked up properly any more. More info on the type of task and what you are trying to do with it would be very helpfull.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -