June 30, 2010 at 4:46 am
Hello, I am using SQL 2008 SSIS to copy one file to another folder :
I defined 5 variables :
destpath, value : C:\222\
myfilevalue, value : PRODUCT.TXT
sourcepath, value : C:\111\
fullsourcefilepathname, value : @[User::sourcepath] + @[User::myfilevalue]
fulldestfilepathname, value : @[User::destpath] + @[User::myfilevalue]
I created a File System Task :
Operation : Copy file
Source Variable : User::fullsourcefilepathname
Destination Variable : User::fulldestfilepathname
I didn't create any Connection Manager.
But I got this error during the execution :
Source: File System Task File System Task
Description: An error occurred with the following error message: "The path is not of a legal form.".
Do you know why ?
June 30, 2010 at 6:13 am
If you go to the properties pane of the File System Task and you go to expressions (where you set the different paths), you can go to the expression editor. There you can evaluate the expression.
What results do you get?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 1, 2010 at 9:22 pm
No, there is nothing in Expressions.
What should I enter there ?
July 2, 2010 at 1:45 pm
July 5, 2010 at 8:58 pm
Hi there
this may be help you out if needed...
let me know if i can help further
cheers
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply