Executing Legacy DTS packages

Question

Executing Legacy DTS packages

SQLBuddy123

One Orange Chip

Points: 28294
More actions
June 26, 2009 at 9:36 am

#135466

Hi,
Could anyone tell me how to execute (with an example if possible) the 32-bit legacy DTS packages that were copied from a 32-bit SQL Server 2000 instance to a 64-bit SQL Server 2005 instance?
Thank You,
Yours
SQL Buddy

Viewing 14 posts - 1 through 13 (of 13 total)

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

MannySingh SSChampion Points: 12465 More actions · Answer 1

Could anyone tell me how to execute (with an example if possible) the 32-bit legacy DTS packages that were copied from a 32-bit SQL Server 2000 instance to a 64-bit SQL Server 2005 instance?

OPEN SSIS in Management Studio-> goto MSDB Folder and you will see the package sin there...

Right click and run the package or create a job to schedule the package:

Best Practise is to convert the package from DTS to SSIS... or use DTUTIL through commandline..

Maninder
www.dbanation.com

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

Hi Mani Singh,

Thank you very much for your reply.

Could you tell me the command that should be included in the DTS

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

Hi Mani Singh,

Thank you very much for your reply.

Sorry for my previous message.

It was not complete. I somehow pressed Enter in the middle of that message.

Could you tell me the command that should be included in the SQL Server Job step to execute the DTS package like

DTSRun /S "XYZ" /U "sa" /P "password" /N "DTS_Package_Name"

I think we should not use this command on 64-bit SQL Server. Could you tell the exact command that should be typed in the Job step.

Yours

SQLBuddy

MannySingh SSChampion Points: 12465 More actions · Answer 4

sqlbuddy123 (6/26/2009)
Hi Mani Singh,
Thank you very much for your reply.
Could you tell me the command that should be included in the DTS

Correction it is the dTEXEC command and not DTUTIL.

what do you mean by "included in the DTS" do you need the DTEXEC command or how to include the DTS packagges in the JOB.?

For DTEXEC search BOL.

Maninder
www.dbanation.com

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

Scheduled SSIS job code:

/SQL "\Package location under msdb folder with its name" /SERVER "SQLInstanceName" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

MJ

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

Hi Manu,

Thank you very much for your reply.

But, I didn't understand how to enter the value for "\Package location under msdb folder with its name" .

Also don't we need to mention user name and pass word in that code.

Could you please explain the code you had provided with an example?

Thanks,

Yours

SQL Buddy.

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 7

SQL Server Integration Services Package Scheduling with SQL Server Agent

http://www.mssqltips.com/tip.asp?tip=1180

The code that I provided is for scheduling ssis package stored in msdb database. Just open Jobs under sql server agent and specify the package location. It will automatically generate the command line for you(that I mentioned earlier).

MJ

kkiranvarma Valued Member Points: 71 More actions · Answer 8

Hi Manu,

Thank you very much for your reply.

I really appreciate your help.

Yours

SQLBuddy

EdVassie SSC Guru Points: 60472 More actions · Answer 9

There are lots of threads on this topic. See my post on http://www.sqlservercentral.com/Forums/Topic737423-146-1.aspx for more details of the setup you need to run DTS on SQL Server 2005 and 2008.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

R_Casey SSC Veteran Points: 293 More actions · Answer 10

Hi. I found that to run a DTS 32 bit package I needed to use the 32 bit executable in the job step exec statement as below. If you need you can also put in user name and password but mine are parameterized.

Yes, this was quite confusing at first...

C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /DTS "\MSDB\PACKAGE NAME" /SERVER SERVERNAME /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

Good luck.

-Kim

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 11

SQLBuddy123

One Orange Chip

Points: 28294

June 29, 2009 at 11:06 am

#1016994

Hi EdVasse,

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 12

Hi Edvasse,

Thank You very much for your reply.

I really appreciate your help.

Yours

SQLBuddy

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 13

Hi Kim,

Actually, I was looking for this kind of solution. You are very straight to the point.

Thank you very much for your reply.

I really appreciate your help.

Yours

SQL Buddy.