Hi All, Its a very simple task to move the file from FTP to local. First i tried to FTP the file from the server to local from FTP client (Core FTP) and it FTPed the file correclty.On Unzipping it gave the .csv file. When i am trying to do the same task from SSIS FTP Task, it is getting the file from FTP to local. But when i unzip the file it converts the format to .BAK instead of .csv. Has anyone faced this issue? Attached is the screen shot: Thanks & Regards

Hi agarwalr, What step you have taken to configure the FTP Task in SSIS, and you can alos refer to the following articles as a reference: http://www.ssisguru.com/2009/10/unzip-and-zip-files-using-ssis.html http://microsoft-ssis.blogspot.com/2011/01/unzip-files-with-ssis.html Hope that helps. Thanks, Eileen

I know this is an old thread, but wanted to add an observation. I'm running into this issue as well, but only on a specific machine in our environment. I did notice, that the .bak file is actually a copy of the zip file. If you rename the .bak file to .zip, you'll be able to open the archive and view contents. I still haven't figured out why this is occurring only on our specific production server.

Your culprit (more than likely) was a component of Redgate software on that machine. I had the same issue. I turned some Redgate services (Hyperbac perhaps?) off and no longer had the .bak file extension name issue.

can you experiment to make sure it is? Otherwise it does not add much to the solution.Arthur My Blog