August 29, 2007 at 3:12 pm
Hello,
I've set up a Data Flow Task with an OLEDB Source to an Access query. The query returns MAX(FileDate) AS MaxFileDate and CSTR(FileDate) AS FileDateChar. FileDate uses the Access database type 'Date/Time' (short date format).
I then have a Data Conversion Transformation to convert MaxFileDate to DT_DATE. The Output Alias is 'MaxFileDate_Out'.
Then I have a RecordSet destination. The variable that contains the RecordSet is called AccessFileDate and is typed as Object.
When I execute the Data Flow, it appears to run without a problem. How do I extract the MaxFileDate_Out value from the AccessFileDate variable? I need to use the value in the Precedence Constraint between two other Data Flows. That Precedence Constraint will contain an expression like this;
@[User::FileDate] > @[User::AccessFileDate (MaxFileDate_Out)]
In other words, I need to check to see if the MaxFileDate_Out value in the AccessFileDate variable is greater than the value of another variable called 'FileDate'.
Can I consume the AccessFileDate variable value this way?
Thank you for your help!
CSDunn
August 30, 2007 at 9:06 am
Never mind on this. I wound up using a script task.
CSDunn
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply