Help friends, i have a trouble with the script to generate the script out of all dts..

• Hector Angello Silva Carmona

  SSCrazy

  Points: 2720

  More actions

  April 8, 2005 at 5:06 pm

  #163227

   

  Help i have a trouble with the script to generate the script out of dts

   

   

   

  exec master..xp_cmdshell 'DTSRUN.exe -S"DESING_NT4" -N"Traspaso_Archivo_Bajas_CTC_3" -V"A3A3AB7A-1DBD-48C6-8678-C64A0AFC3B89" -F"C:\DTS\20050408\Traspaso_Archivo_Bajas_CTC_3.dts" -E -!X '

  DTSRun:  Loading...

   

  Error:  -2147220465 (8004040F); Provider Error:  0 (0)

     Error string:  Cannot Load, Save or Execute the Package if some objects do not have a Name. Please specify Names for these objects.

     Error source:  Microsoft Data Transformation Services (DTS) Package

     Help file:  sqldts80.hlp

     Help context:  701

   

  NULL

  (9 row(s) affected)

  why occurs that? thanks friends

   

• April 11, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  April 11, 2005 at 8:35 am

  #551853

  Does this work if you execute it in the DTS Designer?

• Hector Angello Silva Carmona

  SSCrazy

  Points: 2720

  More actions

  April 11, 2005 at 8:57 am

  #551871

  No, i dont, the DTS designer is closed......

  mmmmmmmmm