How to include DTS in Jobs? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

How to include DTS in Jobs?

Author

Topic

itpetiks
Starting Member

6 Posts

Posted - 2006-04-04 : 11:08:31

Hi just want to ask...

I need to run a DTS (that updates a SQL table from an ORACLE table) in a schedule JOB. how do i begin?

tnx in advance.

Denz

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-04 : 11:33:00

Right Click on the DTS Pkg Name (in Enterprise Manager)
3rd option from top is Schedule Package

Srinika

EASYSQL
Starting Member

10 Posts

Posted - 2006-04-04 : 11:33:38

Right click on the DTS and click schedule package .
It will walk you through different options.
thanks

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-04 : 11:57:35

quote:
Originally posted by EASYSQL

Right click on the DTS and say schedule package .
It will walk you through different options.
thanks

Is "Speach Recognition Software" running on ur PC ?

Srinika

itpetiks
Starting Member

6 Posts

Posted - 2006-04-04 : 12:16:58

@ Srinika and EASYSQL
Tnx for the quick reply... i was bit confused because
i was tryin to create a job directly in the
--> Managment folder (in Enterprise Manager)
|--> SQL Server Agent
|--> New Job...
instead of doin what you guys have suggested.

tnx again.

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-04 : 12:19:38

itpetiks,
Ur way also seems to be OK

Edit : Its not that easy

Srinika

itpetiks
Starting Member

6 Posts

Posted - 2006-04-04 : 12:39:02

really?, we'll i got lost when creating "Steps" (in New Job Step) form

it was a bit confusing... what type to use and command in creating a DTS job.

please excuse my ignorance... i'm still a newbie in this stuffs.

tnx.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-04-04 : 12:41:42

Or you could just use DTSRUN /S <servername> /E /N <DTDPackageName>

itpetiks
Starting Member

6 Posts

Posted - 2006-04-04 : 14:02:57

@RickD

type: "transact-sql (TSQL)
and command: DTSRUN /S <servername> /E /N <DTDPackageName>

is this how i suppose to do it?

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-04-05 : 05:42:16

No:

Operating system command (CmdExec)

on the steps for the job..

itpetiks
Starting Member

6 Posts

Posted - 2006-04-05 : 14:16:49

ok tnx...

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2006-04-12 : 12:14:22

This is very handy as i was also trying the other way and i was getting confused as to what to type in after the DTSRun

But i've a quick Question when i use the so call "wizard" right click etc.. i get all the code behind the DTSRun can anyone explain what its for or what would a normal one without using the "Wizard" look like?

DTSRun /~Z0xD2CA57C53D2F2113AE4AF9DCF3B9E06C1BC235F9AC0F93874DA1A7A7726551C0331443112985EB18200EDC166DA525803866B6F6A591535D9E66D6F26431E1A31595175A044FBC89D413EB07212346F4EE84F39BDDDE0FB9CA638F4A54CF2149976E990809B54253153740E70D4540B7F09FACD05112ECCE3DC822

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2006-04-12 : 12:28:18

The wizard creates an encrypted version of the command..

What you would use with the wizard is:

DTSRUN /S <servername> /E /N <DTDPackageName>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources