I am trying to zip a file from a sql2005 ssis package and within that package I can either runa command line or vbscript to comapct / zip a file.
When I try to simply zip a file via command line and not through the sql package the command executes but sais o files were compressed. here is the command line i am using, any help is greatly appreciated.
Compact /c c:\sqltest\Testexcelfilecopy.dtsx test.zip
thanks in advance !