mister.magoo (2/20/2013)

---

[sarcasm]Simply set the date bucket parameter to weekly and the range filter from June 2011 to today.[/sarcasm]

Sorry, feeling a bit

Truly...

Create a dates table (with weeks in it)
Add a data flow to grab the weeks from the dates table for the required range and feed that into a package variable (recordset destination)
use a foreach loop to loop through the weeks in the variable
feed the start and end dates from the week into your extract routine (where clause)
output to file (use expression to build file name using week number from loop)


If I have assumed too much knowledge and Google doesn't help , then ask questions by all means

Phil Parkin (2/21/2013)

---

Alternatively, add a Conditional Split in the data flow and split the data into four streams - to four separate files.

SQL_Surfer (2/20/2013)

---

Thanks. Another question. I have a for each container that reads dates from the table. Inside the container, I've execut SQL task. I did the parameter mapping and seems like I can't access date variable in execute SQL task. Getting syntax error or access violation error. Any idea?

mister.magoo (2/21/2013)

---

I like this idea, but only if every month has four weeks in it

SQL_Surfer (2/21/2013)

---

I have a table which stores date per week. I am passing those dates to my inline statement (in execute sql statement).