Where are my SSIS packages stored?

• Noc234234

  Old Hand

  Points: 335

  More actions

  February 20, 2009 at 11:09 am

  #131142

  I can't find my SSIS packages in the database. I have a SSIS server, and when I do 'import package', it shows my packages in the list, but where are they stored in the database?

  I checked MSDB but don't see any tables with SSIS in the name?

  Also, is there a simple way to launch the Import Wizard from the SSIS Integration Server? I have to connect to my Database server, pick a random database and right click. Why do I have to do that if I'm doing something simple like transferring between two text files?

• Jay1234

  SSCommitted

  Points: 1624

  More actions

  February 20, 2009 at 12:28 pm

  #947800

  SSIS packages are in msdb.dbo.sysdtspackages90

  For details go to http://msdn.microsoft.com/en-us/library/ms181701(SQL.90).aspx

  To launch Import/Export Wizard - Go to Start > Run > dtswizard