Schedule DTS package in SQL Server 2005

Question

Schedule DTS package in SQL Server 2005

VRT

SSCertifiable

Points: 5776
More actions
February 13, 2009 at 9:06 am

#130943

Hi,
I have DTS package which was developed in SQL Server 2000. I successfully imported into SQL Server 2005. When I run the package it is successfully executed.
Now, I am not able to schedule this dts package as job in sql server 2005.
Any help is more appreciated? Kindly help me? How can I schedule the dts package in sql server 2005?
Thanks a lot,
Venki.
Thank You

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Did you convert it to an SSIS package, or leave it as DTS?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 2

You are not able to schedule it? What's wrong, can you not get to the SQL Job agent UI in management studio? Are you unable to find it in the list of packages? Is the package getting some kind of an error?

What is actually happening?

VRT SSCertifiable Points: 5776 More actions · Answer 3

Thanks a lot for your quick replies.

I didn't change the DTS to SSIS. I kept as it is.

When I am trying to schedule it i.e. I tried add it as job but when I select the sql server and it was not coming into that list. The list has all the other SSIS package but not the dts package.

May be I tried wrongly?

Can you tell me the procedure how to add that to jobs or schedule it as job?

Thanks in advance,

Venki.

Thank You

Greg Charles SSC-Forever Points: 45403 More actions · Answer 4

You can't right-click on a package in SQL 2005 Management Studio and create a job like you could in SQL 2000 Enterprise Manager. In SQL 2005, you have to create the job and add a step the executes the package using DTSRUN.

Greg

VRT SSCertifiable Points: 5776 More actions · Answer 5

Greg Charles (2/13/2009)
You can't right-click on a package in SQL 2005 Management Studio and create a job like you could in SQL 2000 Enterprise Manager. In SQL 2005, you have to create the job and add a step the executes the package using DTSRUN.

Can you elaborate a bit?

What is DTSRUN? Is it a command where we have to give like

DTSRUN in Transaction SQL?

Can you guide me please?

Thanks a lot,

Venki

Thank You

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 6

venki (2/13/2009)
Greg Charles (2/13/2009)
You can't right-click on a package in SQL 2005 Management Studio and create a job like you could in SQL 2000 Enterprise Manager. In SQL 2005, you have to create the job and add a step the executes the package using DTSRUN.
Can you elaborate a bit?
What is DTSRUN? Is it a command where we have to give like
DTSRUN in Transaction SQL?
Can you guide me please?
Thanks a lot,
Venki

DTSRUN is documented is SQL Server Books Online.

If you look at one of the jobs you scheduled in SQL 2000, you will see it's executing DTSRUN.