Sorry, this is one of those things that is very difficult to track down. One thing you might do is before you run the process that fails is save off...

Probably. Profiler will at least tell you if this is doing something on your box. It might be doing something on another SQL box, in which case, you'd have to...

Yes. When running Active/Active, you have 2 SQL Servers. there is, of course, a shared virtual SQL Server as well, but the two instances "pose" as this virtual.

change them...

Perhaps. You'd have to have a reference to the existing package and then add an object to it.

Is there some reason you do not want to call another package?

Steve...

You might try searching for some .DTS files on the server and see if there are any.

Steve Jones

steve@dkranch.net

You can query to see if new objects have been created. There is a create data in sysobjets. If the objects are altered, however, you cannot determine this with a...

Not sure about the syntax for the BCP. Guess you'd need a shell of some type.

To execute another package:

Dim oPkg, intError

Set oPKG = CreateObject("DTS.Package")

oPKG.LoadFromSQLServer strServerName, , , 256, , ,...

I wouldn't do this in a trigger. Instead, use the trigger or the original code to insert a value into some process table. Then have something that runs every minute...

Some good information at:http://www.sqlsecurity.com/

Steve Jones

steve@dkranch.net

It could be running from a COM file, a .DTS file. What is the job definition?

Steve Jones

steve@dkranch.net

I do this as well and have some writing going on for this. I have a separate package that does the import for my files since all of them are...

My guess is that SQL is performing an implicit conversion. This means that SQL will attempt to automatically convert a character to an integer if that is the destination field...

Are these different formats of files? Do the names changes? If there is some pattern here you can do it. Look at the FileSystemObject. It will allow you to get...

This should be dependent on your client program. What driver/data access method are you using?

Steve Jones

steve@dkranch.net

If you want to "lock" a row, or series of rows in SQL Server so only one edit at a time can occur, I'd use a flag instead. It isn't...