Where the SSIS package saved in SQL2005
-
Can any one tell me where the SSIS package saved in SQL server2005 Standard edition.??? I made one import package , but i don't know where it is saved in SQL2005. Thanks in Advance. Aman
-
Can any one tell me where the SSIS package saved in SQL server2005 Standard edition.??? I made one import package , but i don't know where it is saved in SQL2005. Thanks in Advance. Aman
Depending on your deployment, they are generally stored either on MSDB database or in the file systems. I basically use VS 2008 and MSSQL2005 and the SSIS packages are stored in
drive name:\Documents and Settings\My Documents\Visual Studio 2005\Projects
Or else you can also look into thru the defined projects path in Tools>Options of Visual Studio Anyway, for more details on How to: Save a Package to the File System visit this link [ http://msdn.microsoft.com/en-us/library/ms137970.aspx[^] ] How to: Save a Copy of a Package in MSDB database [ http://msdn.microsoft.com/en-us/library/ms137565.aspx[^]] Hope this helps :)
Niladri Biswas