August 31, 2009 at 6:40 am
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
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
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
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