Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
FTP Task in SSIS changing the file extension

Answered FTP Task in SSIS changing the file extension

  • Monday, October 24, 2011 9:40 PM
     
     
    Sign In to Vote
    0

    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
     

All Replies

  • Thursday, October 27, 2011 10:08 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    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
     
  • Wednesday, May 16, 2012 2:36 PM
     
     
    Sign In to Vote
    0

    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 PM
     
     
    Sign In to Vote
    0
    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.
     
  • Thursday, May 17, 2012 7:57 PM
    Moderator
     
     
    Sign In to Vote
    0

    can you experiment to make sure it is?

    Otherwise it does not add much to the solution.

    Arthur My Blog