Running SQL task via DTS

[Minimorgie]

Hi,

I am populating a table via SQL which is run as part of a DTS on SQL Server 2000. This has been running fine until now. the SQL has started omitting to populate some fields, if I run it as a seperate task from the DTS or via Query Analyser it runs correctly so I don't think there is anything wrong with the script. The task is the last one in the dts but I have tried adding another one after it to see if this does the trick but it doesn't.

Any ideas?

Thanks

Minimorgie

 

[Minimorgie]

Please ignore this thread. I have worked out the solution myself. There was a missing workflow which had somehow got deleted!

Thanks
Minimorgie