Question

  Asked: Jun 13 2008   10:14 PM GMT
  Asked by: John t


dtexec scripts just deleting data


DTEXEC, DTS, SQL Server Express, SQL Server Express Manager

since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the import\export wizard are simply deleting all data in my target tables (when run via. dtexec), Yet they work ok from the wizard, and worked ok a few weeks ago. I don't understand what this can be caused by. Thanks for any help.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



I would assume that something within the package isn't configured correctly. Is there any output when you run the package or any error data to indicate a failure?
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400 and SQL Server.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register