All want is I got two files in CSV format, PLUSale and ProductCatalog. I need to compress them and move the files to indiviual directory thats all.
Below script works fine, but it has to ZIP the files with same name as CVS file. Which I am not understanding how to do
set SSIS_FTPFILE_ORG=I:\Information Technology\Retail\Durga\OsPos\Store Files\
set SSIS_FTPFILE_DEST=I:\Information Technology\Retail\Durga\OsPos
"C:\Program Files\7-zip\7z.exe" a "%SSIS_FTPFILE_DEST%\ProductCatalog\ProductCatalog.zip" "%SSIS_FTPFILE_ORG%\ProductCatalog.csv" >>"%LOGFILE%"
"C:\Program Files\7-zip\7z.exe" a "%SSIS_FTPFILE_DEST%\PluSales\PluSales.zip" "%SSIS_FTPFILE_ORG%\PluSales.csv" >>"%LOGFILE%"
Any help please.