dbTalk Databases Forums  

how to save ssis packages before next database restoration

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss how to save ssis packages before next database restoration in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #41  
Old   
Charles Wang[MSFT]
 
Posts: n/a

Default 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.
================================================== =======



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.