Error with DTS Run ..Plz look at this

• thisguyrox

  Mr or Mrs. 500

  Points: 546

  More actions

  March 6, 2009 at 12:04 pm

  #131984

  Hello,

  I have imported a DTS Package as a structured file into SQL Server 2005 under Legacy and I am trying to execute it from Management Studio as below:

  xp_cmdshell 'DTSRun /SABCSQL /E /Ntestdbpkg'

  Im getting the below error:

  Error string: The specified DTS Package ('Name = 'testdbpkg'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

  I have verified that the DTS Package is present in msdb..sysdatpackages table.

  Please help me with this.

  Thanks,

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 9, 2009 at 10:55 am

  #956213

  Is this a named instance?

  Greg