March 9, 2011 at 4:16 am
Hello,
I have some Packages in the "File System" Folder of Integration Services
(e.g: Gespeicherte Pakete->FileSystem->Post-CD Pakete->dts_ZAM_RegioViews_to_RegioTables)
What it the way to copy these to a another Instance on another Server?
Thank You
Joachim
Edited with vim
March 9, 2011 at 5:31 am
There are several options:
* as they are just packages in the file system, you could go to folder where they are stored, copy them and them paste them in the appropriate folder on the other server.
* you could right-click on every package and choose Export...
* you can script it out using the dtutil utility http://msdn.microsoft.com/en-us/library/ms162820.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2011 at 5:54 am
> as they are just packages in the file system, you could go to folder where they are stored, copy them and them paste them in the appropriate folder on the other server.
OK, and, provided that I am gonna find the file location and copy files, are the files automatically unter control of the new IS?
> you could right-click on every package and choose Export...
OK, when I want to export to "File System" I guess I can't choose the Files System of the new Server, or can I?
- Joachim
Edited with vim
March 9, 2011 at 7:25 am
Schuttberg (3/9/2011)
> as they are just packages in the file system, you could go to folder where they are stored, copy them and them paste them in the appropriate folder on the other server.OK, and, provided that I am gonna find the file location and copy files, are the files automatically unter control of the new IS?
> you could right-click on every package and choose Export...
OK, when I want to export to "File System" I guess I can't choose the Files System of the new Server, or can I?
- Joachim
Regarding the first question:
it will only show the packages if they are placed in certain folders. For more information, see:
http://msdn.microsoft.com/en-us/library/ms137916.aspx
Regarding the second question: I don't know 🙂 I never used the file system option myself before, but you can always try it out of course.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply