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

* Copy-ISItemSQLToFile

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.