DtExec Command

• Agson Chellakudam

  Ten Centuries

  Points: 1387

  More actions

  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

   

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  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://www.sqlservercentral.com/columnists/vRainardi/migratingdatawarehousesystemstosqlserver2005.asp

  Markus

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

• Agson Chellakudam

  Ten Centuries

  Points: 1387

  More actions

  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