+1 that's what I'd do too.

No problem. My colleagues love the fact that I'm an amateur proofreader as well as a SQL Server professional:w00t:

And...

DaveDB (1/7/2014)

---

Hello and happy new year!

I wrote a stored proc that basically aggregates some data based on how many Monday's, Tuesday's, Wednesday's etc in a current month (date range parameters)....

I can't see any way of doing this directly, without using an additional param.

But logically, within your proc, can you assume that the nesting level can either:

1) Remain the same

2)...

rswinehart (1/2/2014)

---

You could use an expression to calculate the file name, if the naming is consistent.

If you feel you cannot create a naming rule that would always work,...

There are some issues that you will face with this solution.

Let's assume that you have the packages developed & deployed. You have 12 SQL Agent jobs created. You have built...

Sowbhari (1/3/2014)

---

If you can change the stored procedure to output as a concatenated string of the required columns data delimited with "," for the respective customer then you can write...

You are not clear.

What is MNC?

What do you mean by 'real time'?

Visual Studio (in the form of BIDS or SSDT) is the...

Ok. The workaround you found does not apply for 2012. Instead, please search for 'with result sets'

Sorry but I'm not at my PC so cannot post something more detailed right...

Which version of SSIS are you using?

Jeff Moden (12/30/2013)

---

Phil Parkin (12/30/2013)

---

Not out of the box.

In the case you've mentioned, it's probably easiest to set up two data...

Try running this to check the account that xp_cmdshell is using - it probably is not yours:

xp_cmdshell 'whoami.exe'

Not out of the box.

In the case you've mentioned, it's probably easiest to set up two data flows which separately handle...

DaveDB (12/27/2013)

---

Dude, I am asking for a simple PIVOT example. I am not sure why this is an issue? Please do not clog up my post with links. I am...

Also, I think your parameter should be called '0' rather than 'code'.