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 :hehe::w00t:

Truly...

Create a dates table (with weeks in it)

Add a...

I'd say that the first thing you should try is some query optimisation - maybe you can get the query running fast enough so that you don't need to do...

There are almost always alternatives, and knowing the pros and cons of each is a really useful thing. In this case, once data is in a staging table I would...

I did not say it wouldn't.

My suggestion is to perform the deletion as part of the control flow -...

Maybe you could come at this from another angle.

Why not put a rowcount transformation underneath the script component and then delete the file in the control flow if [rowcountvariable] ==...

Jacob Pressures (2/19/2013)

---

I just used the unpivot tool. So now I have more columns than I need. I know how to map the columns. If I need to use...

sunder.mekala (2/19/2013)

---

Just to make calrify, my requirement is i have 5 ole db sources that i have load it into a SINGLE flat file

why 5 ole db sources?

As i dont...

I don't know what you mean when you say "..flat file formatting is delimeter," but from what I can...

Not true for negatives. Try this:

select -11.2 - floor(-11.2)

But stick to...

Loads of examples of this all over the Internet, but try this for starters & see whether it helps.

opc.three (2/18/2013)

---

Good to know you have a way forward but it seems like a Script Task would be a better choice here to save you a round-trip to the database...

And here's a really obvious (yeah right!) way of making Lynn's example work:

declare @DateVal datetime;

set dateformat mdy;

set @DateVal = '2013-02-14T00:00:00';

select @DateVal;

go

declare @DateVal datetime;

set dateformat dmy;

set @DateVal = '2013-02-14T00:00:00';

select @DateVal;

go

Are you sure that having a single flat file containing mixed data would be an acceptable solution? Sounds like a real mess to me, but, funnily enough, I had to...

Your ExecuteSQL task will have associated with it a system variable called ContainerStartTime, scoped only at the task level. Maybe that is worth a try.

I apologize once again if that will help.

I would have removed this post if it was in my hands, but please give me a chance to explain that I was...