SQL Server - How to unzip a File in SSIS? - Feb 27, 2010 at
11:50 AM by Shuchi Gauri
How to unzip a File in SSIS?
One can use the Execute process task available under Control Flow task to unzip
a file in SSIS. Steps to do so:
-
Drag and drop Execute Process Task to the control flow.
-
In Execute process, provide the path of the executable (Executable), provide
arguments to extract the zip files (Arguments), and provide working directory
for processing (Working Directory) configurations.
SQL Server - How to unzip a File in SSIS? - May 05, 2009 at
22:00 PM by Rajmeet Ghai
How to unzip a File in SSIS?
Execute Process Task in the Control Flow task can be used to unzip a file. The
execute process task needs to be dragged and dropped to the control flow
followed by configuration of Executables to specify the path of application,
Arguments to extract zip files (path) and Working directory.
SQL Server - How to unzip a File in SSIS? - June 21, 2009 at
09:00 AM by Amit Satpute
How to unzip a File in SSIS?
Use the Execute Process Task in the Control Flow task.
In BIDS, drag and drop an Execute Process task to the control flow and
configure.
In the Execute Process, you need to perform three configurations:
1. Executable: This is the path of the application you are going to use.
2. Arguments: Arguments to extract the zipped files.
1. e: stands for Extract files to current directory.
2. Then the full path name of the zipped file.
3. –o+: overwrite existing files.
3. Working Directory: Current directory for the process.
Also read
SSIS has the ability to send SSRS report in different formats like Excel, PDF
etc.....
SSAS database backups can be taken using SQL Server Management Studio
(SSMS)......
Auto incremental numbers in a SSIS package can be provided using script
components...........
Lookup transformation combines data from two sources. The fields of these
sources are matched......
|
