RE: how to save ssis packages before next database restoration -
04-04-2008
, 04:26 AM
Hi Betty,
For database restoration, the files in the folder C:\Program
Files\Microsoft SQL Server\90\DTS\Packages will not be removed. Database
restoration only impacts the related database files such as .mdf, .ndf and
.ldf files. Anyway it is always a good practice to backup the files before
you do any uncertain operations.
If you have moved the SSIS packages to other place, actually you need not
copy them back to the folder C:\Program Files\Microsoft SQL
Server\90\DTS\Packages, though you can if you want, you can directly import
the packages from SSMS under File System folder via the following steps:
Right click File System folder, click Import Package, select Package
location as File System, click the button at the right side of Package
path, and select your package to import.
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ======= |