By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

Ssis Package For Moving/renaming File

P: 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
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
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.