When Windows Authentication is used within a DTS package for connection objects, it is not specific to the NT account that created the package. For example, if you run...

Option 1)

My preferred method would be to use DTS. To summarize, here are the steps I would take:

Assumptions:

- All files to be loaded are in one directory

Steps:

- Create a...

When I want to change the name of an existing connection, I always use the "Disconnected Edit" feature to change the name. Renaming through the GUI will always result...

When a data page is not in the cache, the next request for the page will cause the disk to be read, and then the page will be written to...

All processing that moves data from one object to the next in the DTS package will be done at the client. For example if you have a data pump...

If you use sp_executesql with named parameters the query optimizer is more likely to re-use the query plan created the first time the stored procedure was run.

For Example:

sp_executesql N'select *...

Your best bet would be to use SQL Profiler to run a trace that will be active when the delete trigger fires. Books Online will explain how to use...

If the requirement is to be able to pass the data that your company accumulated to the customer, then I would export the data to text files using DTS or...

Ensure that the service account running the SQL Server Agent service on the server you are having trouble with has permissions to select data from the tables you are attempting...