You asked for someone to say what you are doing wrong without saying what was or was not taking place when you tried to run this package.  Does it give...

There's an awful lot of dynamic SQL going on there, and I don't have time to try and make sense of that much query today, so let me at least...

I think I see what you're trying to do, but I have no idea why you want to do things that way.   It seems tremendously inefficient to hold onto a...

First, that file location has to have permissions set so that the execution context of your SSIS package has access to that path.   Then you just specify the path.   If...

But do you understand how that works?   I have to assume that if you understood it, you'd have already tried it.   I doubt that understanding that query you linked to...