469,946 Members | 1,805 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Ssis Package For Moving/renaming File

6
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
Apr 11 '08 #1
1 2829
ck9663
2,878 Expert 2GB
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
Apr 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by ansonee | last post: by
3 posts views Thread by =?Utf-8?B?TWljaGFlbA==?= | last post: by
2 posts views Thread by pvong | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.