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'.

Try using an OLEDB connection instead.

Please implement Chris' suggestion and see whether that helps.

I've just noticed that your WHILE loop does not appear to do anything, because the 'TOP' clause has been commented out.

My transaction...

Also, you mentioned that this will be an 'ongoing process'. Yet your method does not deal with updates or deletes, is that OK?

You could also try forcing transaction commits in your WHILE loop:

WHILE @@rowcount > 0

BEGIN

begin tran

INSERT INTO tblPricingExc2 --table tblPricingExc2 has an Identity column as PK.

( Key ,

Flag ,

Id

)

SELECT --TOP (10000)

tmpExc.Key...

After creating your temp table, try putting an index on its Id column.

You should still...

Easy enough - just use start...