Problem with Simple ScriptTask

I am new to SSIS 2005. we have a text file with large amount of data. we need to transform it to a database table. Before truncating and loading the table every time the package runs, we want to check with a column(date) in db with file creation time. So for that I created two variables(A,B(value:default N)). And in the data flow, using oledb source got the column value from db and then I passed it to script component. In that script component I take the input as the value from db and checked it with file creation time if its less than the file creation time(date) then make the other variable (B) as Y else N.
Now In the control flow I have dataflow and sql task so using prescendense constraint, I kept as constraint and expression and make the expression as @.B == "Y" to make the flow from dataflow to sql script.
Dont know whats wrong but I think the variable value of B is not changing or not coming to control flow from data flow.
Please help me over here.
Thanks,I really don't understand what you're trying to do here but it sounds as though at some point you are setting the value of a variable from within a data-flow script component.
Why are you doing this? I can't think of many situations where it would be a good idea.

-Jamie|||I am a bit confused as to what you want to do here. If you want to

check a file date then you would not be doing this in the pipeline. It

would be in the Control flow.

Here is what I presume you are wanting please correct me if I am wrong

Check a File date in a DB table with the date of the file at which you

are looking

Based on what is returned you carry on with the package (Data Flow Task)

or not.

Is that right?

Here is how you would probably solve this one

ExecuteSQL task to get the date from the DB Table

Script Task to get the date on the file in question

Same script task compare your two dates

Set an external variable to a value.

Have a conditional precedence constraint that executes the Data Flow

task based on whether the variable value returned is good AND the Script

task succeeds.

Is that it?

Allan

"PavaniPolu@.discussions.microsoft.com"

wrote in message

news:17d9c02f-2e8c-46c1-b1bc-ee650b8d6b5b@.discussions.microsoft.com:

> I am new to SSIS 2005. we have a text file with large amount of data. we

> need to transform it to a database table. Before truncating and loading

> the table every time the package runs, we want to check with a

> column(date) in db with file creation time. So for that I created two

> variables(A,B(value:default N)). And in the data flow, using oledb

> source got the column value from db and then I passed it to script

> component. In that script component I take the input as the value from

> db and checked it with file creation time if its less than the file

> creation time(date) then make the other variable (B) as Y else N.

> Now In the control flow I have dataflow and sql task so using

> prescendense constraint, I kept as constraint and expression and make

> the expression as @.B == "Y" to make the flow from dataflow to sql

> script.

> Dont know whats wrong but I think the variable value of B is not

> changing or not coming to control flow from data flow.

> Please help me over here.

> Thanks,sql