Configuring SSIS Repository
Hi, When we store our SSIS Packages, they are stored normally in MSDB system database. Is it possible to configure it to store the packages in a user-defined database? Where do we make these changes? Please share more details, thank you.
December 15th, 2010 1:08am

Hi, I do not think SSIS packages can be stored in user defined databases.
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2010 1:30am

I don't think user databases are supported. Saying that you can edit the configuation used by the SSIS Service to manager the "folders". See http://msdn.microsoft.com/en-us/library/ms137789.aspx Therefore I don't see why you cannot add more nodes with a user databases, e.g. <Folder xsi:type="SqlServerFolder"> <Name>MyCustomDatabase</Name> <ServerName>.</ServerName> </Folder> You would have to replicate any objects requried, obviously the tables but also stored procedures as well. Using SQL Profiler will allow you to snoop on what happens under the covers and find out what you need to do, but start with anything with sp_dts* stuff. Not supported it seems, but it may work, and if you have a strong enough reason it may help.http://www.sqlis.com | http://www.konesans.com
December 15th, 2010 7:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics