I am trying to execute an update query in an Execute SQL Task of the
following kind:
update a
set a.emploeeno=b.employeeno,

     i have three DTS package in my local computer and i schedule them in
one sql agent job as three steps,
     my question is that any commands i can write in stored procedure
to call this job instead of calling DTS package three times?

     Is there a way to change in a DTS package a specific server?
     I explain why.
     I have about 140 DTS packages who collects data from an AS/400 to
store in several SQL databases on a server. Now we ar migrating that server

All,
I've written a DTS package that contains a complex VBScript that all works
fine but the problem is that I dont know how to fire this DTS package from
an INSERT trigger on a table (I specifically want to avoid a scheduled DTS

    i am trying to edit job step and i got a questin when i gonna to
choose job failure action,   I couldn't find QuitWithRollBack this optin.
just wondering does this option exist .  how to find it if it exist? because
i have a job script which has this option.

Our software uses a SQL database and is designed to get rid of data
after a specified amount of time to maintain performance.
We would like to be able to keep that data in another database along
with the up date information for reporting purposes, while leaving the

What security permissions need to be set for a user to view a DTS package in
enterprise manager and then execute it? Are there any server level
permissions (roles) that would keep a user from doing this?
I understand the package runs in the context of the user and its permissions

I have created a DTS package that seems to run fine reporting it has
processed all 5 million records but then there are none in the table - where
would I begin to look?

We have several instances of SQL Server 2000(sp3) on a Windows 2003
development box. (3gigs ram, dual P4 2.8ghz xeons).
We are experiencing a problem where DTS packages are taking an unusually
long time to open. This only occurs when using EM on other clients and not on

I have a datetime field in a SQL SERVER and I need to know clients that are
scheduled for the next day when reading the info on the current day.  I have
tried
[tblevent].[begin_datetime] = dateadd(d,1,getdate())

When trying to open the DTS Designer, I get an error stating Error in the
DLL. It will then open, but when I save, I get the same error. Also, I cannot
open any DTS tasks previously created from another machine.
I have tried reregistering DLLs, and also removing and readding, SQL ...

right now I'm planning to migrate a complete Oracle database (Oracle is
V9.2.0.5 running on a Microsoft Server) to a SQL 2000 Server.
Now the question is, wether DTS is the right tool to do this or not. This is
the first time I'm doing a task like that, so I still try finding the ...

I would like an export to be sent to a user at the first of each day based on
a query.  How is the best way to do this

In activeX I have the following VBscript.
Where I getting the filename and location from Connection
Source.
I need to add the date to the file name by using the code

Hi everyone, I need recommendations about the best way to merge two
identical database tables.
We have two database servers setup as follows
One database is located outside a firewall, all information entered from