Greetings,

I got a transformation which will create a text file from a table.
the query got a where condition between 2 datetime; a datetime from a textfile properties lastmodifiedtime and a datetime using sysdatetime()

Name:  Capture.jpg
Views: 44
Size:  7.9 KB
this is the transformation. i get the file properties using get file name and pass the selected value using select value step and get the value to result using copy row to result step. is this step correct to get pass value to query?

Name:  Capture1.PNG
Views: 42
Size:  15.5 KB
the query, is the query correct for passing value from the textfile properties?

attached below is the transformation for review.
createTextFile.ktr