Post reply

DtExec Command

  • July 31, 2006 at 9:41 am

    #118893

    Hi All

    I am trying to create a job which is executing a Dts Package (present in Legacy) using Dtexec command.

    Workflow name is Database_Setup_Workflow.

    The step I created was

    dtexec  /server Power1 /User sa /Password pass /SQL Database_Setup_Workflow /SET \package.Variables[g_tran_config_main_id].Value;SET0000014

    While executing I am getting an error:

    Could not load package "Database_Setup_Workflow" because of error 0xC001000A.  Description: The specified package could not be loaded from the SQL Server database.

    I am sure that package is present in the server (Under Legacy folder)

    Can any one suggest where I am going wrong?

    Is it possible to schedule a Dts package present in SQL 2005.?

    Please tell me if any other way to run this Dts Package from SQL Agent

    Regards

    Agson Chellakudam

     

  • August 1, 2006 at 7:14 am

    #652579

    Agson,

    I think DTexec onlu works with SSIS packages. Legacy DTS packages you can either run through DTSrun.exe (like in SQL 2000) or by creating a SSIS package which executes the legacy package.

    see also yesterdays article here http://qa.sqlservercentral.com/columnists/vRainardi/migratingdatawarehousesystemstosqlserver2005.asp

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • August 8, 2006 at 1:07 am

    #653771

    Hi Markus

    First of All Sorry for the delay in replying..

    Legacy DTSs are running fine with 'Dtsrun' command.

    Thanks for the information!.

    Regards

    Agson Chellakudam

Viewing 3 posts - 1 through 2 (of 2 total)

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