Monday, October 24, 2011 9:40 PM
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
Thursday, October 27, 2011 10:08 AMModeratorHi 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:
Hope that helps.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, November 07, 2011 6:54 AM
Wednesday, May 16, 2012 2:36 PM
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.
Thursday, May 17, 2012 7:32 PMYour 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.
Thursday, May 17, 2012 7:57 PMModerator
can you experiment to make sure it is?
Otherwise it does not add much to the solution.
Arthur My Blog