I have an ssis package which loads excel file into Sql server...After all the processing is done i am renaming the file(with timestamp) and moving into another folder...It's failing while renaming the folder(if i just move the file without renaming it works file)
Here is the expression i am using for creating Destination variable
estinationDirectory] +"\\"+ @[User::FileName]+"."+@[User:
Variable DestinationDirectory has the folder location, FileName contains original fileName,
Datetime variable has time stamp(something like 20130718122654)
Here is the error message i got (Could not find a part of the path)
If i don't specify filename and datetime i can move the file without any problem....