Thanks for your suggestion, Jamie!

I've made it! I've used a Script Task to check if the file exists, and it worked pretty well!

If it's useful to anyone, here's the code:

Thanks Grant and Lucky.

Grant, your solution seems to work, but I am not sure if I can install that component on the server I am running the packages..

Lucky, could you...

Hi,

I think this should work:

You can replace this: CHAR(39) + @vchFirstName + CHAR(39)

with this: CHAR(39) + REPLACE(@vchFirstName,char(39),char(39)+' + char(39) + '+char(39)) + CHAR(39)

Follow my example (you can execute it on...

Hi,

I tried to create that too, but couldn't either. For my issue, I have used a table (and separated the text through the cells), and it worked fine, but it...

Hi howeld,

I think this is not going to work either. An Expression can return at maximum 4000 characters in a single string (DT_WSTR), otherwise it raises a truncation error, saying that...