DTS Package: EXCEPTION_ACCESS_VIOLATION when saving

My team is getting this message when altering a DTS Package, using SQL 2000 DTS Designer. We have downloaded all the SQL updates (Backward Compatibility, and the one specifically for DTS Save problems. Have tried this in SQL2005 as well. Have uninstalled both of these programs, and reinstalled on local machines. No avail. Here is what happens:

1) Editing an existing DTS Package, such as a Text Change, or simple connection change

2) Saving the file creates the exact message below:

Package Error

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Description: Code execution exception: EXCEPTION_ACCESS_VIOLATION

3) Then you have to choose OK in the windows Popup Box.

4) The DTS is brought back to the original screen, or completely exited out of Designer.

5) From that point, the Package can no longer be opened for editing, unless you open a previous version (which means changes aren't saved.

We have also tried to SAVE AS another filename. This doesn't work either.

Our team has close to 75 DTS Packages, some simple, some more complex. We are corrupting these left and right. This problem happens no matter what is created in the DTS Package.

This is running into our business operations, and we are unable to find out a resolution...HELP

Any insight in this would be greatly appreciated.

Thanks,

Jason

The first thing that you need to do is back up msdb (or export sysdtspackages)! Make sure that you have all of your DTS packages available to reopen. I would first try exporting the package records to another server and see if you are getting the same thing. Possibly something has happened on that particular server.

Lee Everest

www.texastoo.com/sqlblog

dts only selected rows

I have to dts rows by timestamp. For example if my dts downloaded at 10 am then in the next run i want to grab rows updated in the AS400 after 10am. what is the best way to go in ssis?

thanks...

kushpaw

You'll have to store the timestamp somewhere - perhaps in a file or a table, and then use a dynamic SQL statement using that timestamp.

-Jamie

|||

Perhaps, consider to use some sort of execution/audit tables and have your packages to get data extraction timeframesfrom there each time .

Rafael Salas

|||

There is a timestamp field in both sql and as400 tables. I can select the last timestamp from the destination table and query source for that timestamp. Is that what u mean?

-kushpaw

|||

kushpaw wrote:

There is a timestamp field in both sql and as400 tables. I can select the last timestamp from the destination table and query source for that timestamp. Is that what u mean?

-kushpaw

Yeah something like that. That would work.

|||thanks for your suggestion Rafael. this would be an ssis way, just what i was looking for.