DTS Package Name from Job

• sranderle

  Valued Member

  Points: 51

  More actions

  November 17, 2010 at 7:07 am

  #142630

  We are working on migrating a SQL Server 2000 server to SQL Server 2008. We have 48 DTS packages on the old server, and are trying to determine which ones are actually used. In looking at the jobs, I see a lot of steps like this:

  DTSRun /~S 0x9069B3F76B0EC8BC5990B03838464168E56653D26E1A529D /~U 0xF8141F8065D98248 /~P 0x3FD570F35D1BEFA0EBF2AF41755C562A /~N 0x5B92B8FE0B241CBFB4F264BC4D427BF2352B2B9EB07A5751846E7F7E4823AC52D9D813E3628E9C2546D8C4C2A2326BD2CD88F358841FFDB808EF24F5770B6F29381F166B76920F9E274E36B27D3D2882

  I've been using DTSRunDec to extract package names for the jobs running DTSRun /~Z..., but that does not work on the above statement.

  Any help is much appreciated.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 17, 2010 at 9:20 am

  #1251956

  Try the method I mention in this link:

  http://www.sqlservercentral.com/Forums/Topic607599-19-1.aspx

  Greg