Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2008-01-21 : 10:50:48
|
| HiI've recently started creating SSIS packages using Visual Studios. I am trying to find a way of zipping and archiving files in one of the packages. Is this possible?, and if so, is it possible to date stamp the zip files to?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-21 : 11:14:43
|
Filenames can be anything that you can put into a variable and is a valid windows operating system filename.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-01-22 : 10:48:22
|
| Sorry I'm new to this, how would I go about doing this?Thanks |
|
|
|
mhavens
Starting Member
3 Posts |
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-01-23 : 04:29:48
|
| HiThanks for that, I've installed the package, but it doesn't seem to be appearing in my toolbox, does anyone know why this could be?Thanks |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-01-23 : 10:55:34
|
| To get round the original problem I created a batch file which zips the file and then ran it as an 'Execute Process Task". |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-01-25 : 17:12:49
|
| If you are using a batch file, it wounds like you have a command line zip utility. If that is the case, then you might look at using the Execute Process task.Using that task you can set the Exe you want to call and the arguments to pass to the exe. Additionally, if your arguments change at runtime you can get that using an Expression. |
|
|
|
|
|
|
Zipping Files in SSIS