I have a SSIS package that grabs data from SQL table and stores it in a flat file..
This flat file is dynamically named with the help of variables and current timestamp is appended at the end of the file name. ( FileName_201004091445 this is how it will be named)
Now this "DATA" file is created everynight. I have to calculate a checksum and rowcount for the same file and store these values in a different "CHECK" file
Now the input for the check file has the input from the same variable in which the DATA files name is stored and this has a timestamp on it.. now this calculation of checksum and rowcount follows the dataflow task. The dataflow task sometimes takes more than a minute to process so when the checksum part evaluates the variable for file name , the timestamp differs by a few minutes and hence the file name changes and the checksum and rowcount for the same file cant be done... Any work around for this??
so here is the flow of the task
DATA FLOW The "DATA" file is created and name stored in a Variable "FileName"
Calulating The "FileName" variable is used as a source for the CHECK file..
Now because of the timestamp even a minutes difference changes the file name and the CHECK file has a differenct name as input file than what I would like it to have..
All the help is greatly appreciated..