I don't think the datePart variable should be set to Object.

Per simple talk article

https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets/

"Using the Execute SQL task to return a full result set is similar to returning a single-row...

M, you think you could look at what I did on this post

http://www.sqlservercentral.com/Forums/Topic1592460-364-1.aspx?Update=1

I'm getting this error:

Warning: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory...

is it correct that in the second foreach loop container, the filename will be built up using an expression built using two variables: filepart and datepart?

three foreach loops, one nested inside the other.

still worried about how to pass the datepart as part of the filename, since the above didn't work....

is it correct that filename...

no that won't work for me, because I'm trying to work toward a solution where ultimately I can supply the datePart dynamically.

And what I mean by dynamically, is that...

while you were replying I was editing my entry. Important missing part that I added was :

Name: zippedFile/Datatype:String/Value: @[user::namePart]+@[user::datePart]

how would you control the order of processing. Diff on jun 1 has to be processed before diff on jun 2.

would you put a query in the second foreach...

Hi Marinder and Lempster, Thank you both. I think you're both in agreement actually, just that Marinder gave me concrete SSIS steps. Thanks for the details Marinder. I...

The vendor makes a running 'last 7 days worth' of zipped differential files available on their ftp site, 3 per day (one per table). I just have...

right now, this Datewarehousing ETL nightly process has to complete before the QlikView reports can be refreshed. So, a SQL agent job is already engaged in the overall process...

thanks to EE, I googled "execute sql task datetime parameter" to find out how to configure the Execute SQL Task to apply the result of the query to the variable,...

J Livingston, what's unique about my question is that I need the date time stamp created in the control flow.

I'd really like a non-scripting solution for creating...

because I explained to you at least a couple of times, I can't use the ssis package because it is a slow solution. Therefore I'm not using SSIS.

The problem resolved when I provided 'place holder' values in the executable and arguments fields. I was leaving them blank, since I thought that they would populate with the expressions...