Wednesday, March 21, 2012

Saving a package into a folder in MSDB

Hi

I am trying to load a ssis package into a folder (lets say SSIS packages) that I created in MSDB but its geeting saved in the root (MSDB) not into the SSIS packages folder...I am doing this thru C#...

Have you tried using the Application.SaveToSqlServerAs method? The 3rd parameter is the package path and there you can specify the "\folder\folder1....\packageName" format for your package.

More info about Application.SaveToSqlServerAs can be found at http://msdn2.microsoft.com/ko-kr/library/microsoft.sqlserver.dts.runtime.application.savetosqlserveras.aspx

HTH,
Ovidiu

|||Thanx Ovidiu... I also checked that before and now its working fine...

No comments:

Post a Comment