Tony Oswald
asked on
SSIS Flat File Destination as a variable name
I am trying to assign the flat file destination as an expression/variable, and receiving an error
The expression evaluates correctly (see image 1), I have delayvalidation set to true, the file exists (see image 3), but when I run it, I receive an error saying "Error: The object name "\\mgshare01\vol1\APPS\Ftl mb\DMI\Bra nch301_Ser vice1_2015 0604.txt" is not valid. The name cannot contain any of the following characters: / \ : [ ] . =
Can someone tell me what I am doing wrong?
error.docx
The expression evaluates correctly (see image 1), I have delayvalidation set to true, the file exists (see image 3), but when I run it, I receive an error saying "Error: The object name "\\mgshare01\vol1\APPS\Ftl
Can someone tell me what I am doing wrong?
error.docx
ASKER
Tried both, and still the same error...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that was it!! Thanks!
\\mgshare01\\vol1\\APPS\\F
or
with double quote ata the start and end
"\\mgshare01\vol1\APPS\Ftl