Copy-ISItemFileToSQL

Copies an SSIS item from File System to SQL Server.

Syntax

Copy-ISItemFileToSQL [-path] <String> [-destination] <String> [-destinationServer] <String> [[-recurse]] [[-include] <String>] [[-exclude] <String>] [[-force]] [[-connectionInfo] <Hashtable>] [-WhatIf] [-Confirm] [<CommonParameters>]

Detailed Description

The Copy-ISItemFileToSQL function copies SSIS item from File System to SQL Server. The item can be a File System folder or package. Recursive copies are supported.

Related Commands

* Copy-ISItemFileToSQL

Parameters

Name Description Required? Pipeline Input Default Value
path    true  false   
destination    true  false   
destinationServer    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-ISItemFileToSQL.

Return Values

None This function does not generate any output.

Examples

EXAMPLE 1

copy-isitemfiletosql -path "C:\Program Files\Microsoft SQL Server\100\DTS\Packages\*" -destination 'msdb\sqlpsx' -destinationServer 'Z002' -connectionInfo @{SSISCONFIG='.\SQLEXPRESS'}
This command copies all SSIS packages and folders from the File System pathC:\Program Files\Microsoft SQL Server\100\DTS\Packages to Integration Server Z002 folder sqlpsx. In addition changes the Connection Manager named SSISCONFIG data source to .\SQLEXPRESS during the copy process.