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