My doubt is
I am pulling a file list using Execute SQL Task. The query that I am using is
and I selected the ResultSet as FullResultSet and I am passing it to User::FileList
After this I am using a ForEach loop container. Here I used variable mappings as follows
In the loop first I have to check for Earlier data feed and for that I have to get the substring of the FileName that I am pulling into the User::FileList
I am using SQL Execute Task but I am not able to understand how to access the FileName from User::FileList, so that I can get the date from it and compare it with dates that are available in other table in the DB.
I have been trying to do this from two weeks. Please somebody give me a solution
I guess I resolved it. I added one more component to calculate the maximum value of the date and then passed it as a parameter to the next component. This way I dont have to use the aggregate in the other component and so GroupBy is not required.
answered Mar 09, 2012 at 07:22 PM