How to find the location of Package which is running in Job?

• Munabhai

  Default port

  Points: 1445

  More actions

  October 8, 2012 at 4:46 pm

  #269036

  We have some SSIS packages running in SQL Agent jobs. I can see the name of the packages but I can't find the location of the package or project files in the disks so that I can access them with BIDS. Please let me know how I can find the location of the package files.

• mister.magoo

  SSC-Forever

  Points: 47068

  More actions

  October 8, 2012 at 5:05 pm

  #1546972

  It is possible the packages are stored in SQL Server.

  Does the package source for the job step say "SQL Server" ?

  Try connecting to the Integration Services instance in SSMS and browse the object explorer to find them.

  Here is an example...

  

  And how it would look in the job step...

  

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]