Copy-ISItemSQLToFile
Copies an SSIS item from SQL Server to File System.
Syntax
Copy-ISItemSQLToFile [-path] <String> [-topLevelFolder] <String> [-serverName] <String> [-destination] <String> [[-recurse]] [[-include] <String>] [[-exclude] <String>] [[-force]] [[-connectionInfo] <Hashtable>] [-WhatIf] [-Confirm] [<CommonParameters>]
Detailed Description
The Copy-ISItemSQLToFile function copies SSIS item from SQL Server to File System. The item can be an SSIS folder or package. Recursive copies are supported.
Related Commands
Parameters
Name |
Description |
Required? |
Pipeline Input |
Default Value |
path |
|
true |
false |
|
topLevelFolder |
|
true |
false |
|
serverName |
|
true |
false |
|
destination |
|
true |
false |
|
recurse |
|
false |
false |
|
include |
|
false |
false |
|
exclude |
|
false |
false |
|
force |
|
false |
false |
|
connectionInfo |
|
false |
false |
|
WhatIf |
|
false |
false |
|
Confirm |
|
false |
false |
|
Input Type
None
You cannot pipe objects to Copy-ISItemSQLToFile.
Return Values
None
This function does not generate any output.
Examples
EXAMPLE 1
copy-isitemsqltofile -path '\sqlpsx' -topLevelFolder 'msdb' -serverName 'Z002\SQL2K8' -destination 'c:\Users\u00\SSIS' -recurse -connectionInfo @{SSISCONFIG='.\SQLEXPRESS'}
This command Recursively copies all SSIS packages and folders from the Integration Server Z002 folder sqlpsx to the file system path C:\Users\u00\SSIS. In addition changes the Connection Manager named SSISCONFIG data source to .\SQLExpress during the copy process.