472,145 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Ssis Package For Moving/renaming File

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 2918
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.