Executing Legacy DTS packages

  • 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

  • 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..

  • Hi Mani Singh,

    Thank you very much for your reply.

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

  • 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

  • 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.

  • Scheduled SSIS job code:

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

    MJ

  • 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.

  • 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

  • Hi Manu,

    Thank you very much for your reply.

    I really appreciate your help.

    Yours

    SQLBuddy

  • 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

  • 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

  • Hi EdVasse,

  • Hi Edvasse,

    Thank You very much for your reply.

    I really appreciate your help.

    Yours

    SQLBuddy

  • 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.

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

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