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
 SQL Server Development (2000)
 DTS package issue

Author  Topic 

CokoBWare
Starting Member

6 Posts

Posted - 2005-11-16 : 10:27:22
Hi there,

I keep updating a data pump query in my DTS package, and the output never shows the information. I am changing the T-SQL to properly call up the correct information, but it refuses to dump the information into the Access DB I am exporting to. I am also running this DTS package every hour whenever there is data available to transform and export. I've tried changing the data pump query 3 times and the old same behaviour is still there. *ugh*

Does anyone have a clue as to why a DTS package won't update its behaviour when the code has changed? Can anyone provide me with suggestions as to what debugging steps I should take?

Thanks in advance,

Cory Koski
   

- Advertisement -