DTS Package Name

• Gopi Krishnan-319609

  Newbie

  Points: 1

  More actions

  June 26, 2006 at 4:14 pm

  #168983

  Hi,

  I have a job calling DTS Package created through database maintanence plan.Now i cant figure out the DTS package calling through job ? In job we can see as follows. Is there any way to find out what is the DTS Package ?

  DTSRun /~Z0xE8F8C6507F2D61B1F6E661D75024D18CDFA66E59A89E28E4C4D193359AC8928B4EF131F34694989B60FB4E6323AA9B5A7946C4CE5D05EE1134E53F12BC8CBA5BC8C33F156150C6C445E181EF7C5E20E807CDB54E7FC0FEC89304BB3C4338ED298893F5FF40E0C96B52C2DD8BAF17270E3036F50C7FA851E4F2B5805F68E54782B3097EEFA0DCE0807CDCF4DB82B214CC8D9DBA1E8A610D3B18F08A081FA34D5A1378A3C390FDA62782910F2AA52BA8C8B8A81AC6CCAE59EFC8D3ACD076C1690D85FD4476A11B3B7732E319

  Regards

  Gopi

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  June 27, 2006 at 11:54 am

  #646168

  You can find name and Id of DTS in system table in msdb DB

  SELECT * FROM MSDB..SYSDTSPACKAGES

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com

• Carlos Urbina

  SSCommitted

  Points: 1850

  More actions

  June 28, 2006 at 8:24 am

  #646373

  Also review the following, especially the comments by LS

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=232301