Ssis Package For Moving/renaming File

[rush81]

i'm trying to create an ssis package for renaming and moving the file. It gives error at the file system task:

[File System Task] Error: An error occurred with the following error message: "Could not find file 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\abc123.xlsabc.xls'.".

the file is abc123.xls. Now why is it pointing to the C drive?

I have set up five variables as FileName, SourcePath, DestPath, FullSourcePath and FullDestPath.

Can I get some help on this asap

thank you in anticipation

[ck9663]

If your file is "abc123.xls" why is it looking for "abc123.xlsabc.xls". Check your dynamic query. It looks like you need a space there.

-- CK