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

Nomvula (12/20/2013)

---

hi guys

i've created sql task with the following query 'SELECT MAX(wwo.StatusChangedOn) AS MaxDate

FROM wrkWorkOrders AS wwo where wwo.Description = 'Completed Costing' and set up Result...

Karen A. Ferrara-426245 (12/17/2013)

---

I found that using the script task when using a web service to get data works the best. You will need to reference the web service...