Hi SQLRNNR,

I tried it in a new way..seems that there is no error when the package is running...

1. I deleted the expression in the Cozy Roc SFTP Task and

2. simply...

I am checking it now. Anyway, thank you very much!

Hi SQLRNNR,

Attached is the screenshot.

Please let me know if further info is required.

Many thanks!

Jochang

Single file.

Did you happen to send out a report with dynamic dates appended before? How did you do that?

Thanks!!!

No. I got the date because I edited the expression of the connection string in the flat file connection manager, the queries I use are:

@[User::ABC] +(DT_STR,4,1252) DatePart("yyyy",getdate()) +

Right("0" + (DT_STR,4,1252)...

Hi SQLRNNR,

I need to create that in my package and send it out.

Thanks!

Does anyone have some ideas?

When i did it with variables, I

1.create a variable

2. edit the expression of connection string in the flat file connection manager in data flow task

3.edit the...