Post reply

Unable to rename file using File System Task in SSIS

  • August 31, 2009 at 6:40 am

    #225557

    I am using a File system task to rename a file that is placed on one of my hard disk drives. I am writing the following expression

    "D:\\@SSIS\\EOCL_BISEOC.DAT" + (DT_WSTR,4)DATEPART("yyyy",GETDATE()) +".DAT"

    When I do this I am getting the error message that says

    "Unable to Convert System.String to System.Boolean"

    I also got

    "Unable to Convert System.String to System.Int32"

    Please Help ASAP

    Thanks In Advance

  • August 31, 2009 at 7:44 am

    #1046871

    What is "@SSIS" supposed to represent in this expression?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • August 31, 2009 at 12:34 pm

    #1047049

    I'm guessing @SSIS is the pathname? Why don't you just hardcode the path? This is a great article I found for renaming a file.

    http://sqlserversolutions.blogspot.com/2009/04/copyrename-file-using-file-system-task.html

  • September 1, 2009 at 12:58 am

    #1047328

    First of all I would like to thank Rookie as my issue is being resolved with the help of the link you had provided in your reply. Also wanted to say taht @SSIS was a folder i had created locally in which .DAt file had resided.

    Thanks a lot Once again for the great help. :-):-):-):-)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply