SSIS filenames with spaces

Mike Johnson
Mike Johnson used Ask the Experts™
on
How can i use a filename with spaces in it as a datasource? If I take the spaces out of the filename it works.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Inteligence Developer
Commented:
I needed to wrap my variable in quotes using the escape charc  i.e. "/"" + @variable  = "/"";   where the escape character /"  wrapped in opening and closing double quotes i.e.  " " because its within an expression and i'm concatenating a string expression

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial