Issue adding date in PGP Task

Apr 5, 2016 at 3:27 PM
Edited Apr 5, 2016 at 3:29 PM
Hi All,

I'm having and issue trying to manually add date to pgp task for source file and target file. I'm hoping that there is a fix or that I am just doing something wrong.

Expressions

Source File

@[User::file_path] +
(DT_STR,4,1252) DatePart("yyyy",getdate()) +
Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv"

Target File

@[User::pgp_target] +
(DT_STR,4,1252) DatePart("yyyy",getdate()) +
Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv"

Variables
file_path C:\Users\zak.admin\Documents\ECSI\TEST_ADV-1i-
pgp_target C:\Users\zak.admin\Documents\ECSI\TEST_ADV-1i-

PGP task editor is changed to the file path instead of the variable

And I get the following error

TITLE: Package Validation Error

Package Validation Error

ADDITIONAL INFORMATION:

Error at PGP Task: Missing: Source File, Target File.
Error at PGP Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

Can anyone assist me with this issue? If I hard code the date in the variable it work fine.

Regards,
Zak Larson