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

chaseurpuli (12/19/2013)

---

Phil Parkin (12/19/2013)

---

chaseurpuli (12/18/2013)

---

Thanks for your reply Phil. Unfortunately,...

sharmili.net (12/19/2013)

---

Hi Craig,

Thanks for your quick response on this.I understood it was question to check how much I am strong in that.But honestly speaking I don't have experience in ssis...

Raunak Jhawar (12/17/2013)

---

When you say that you have different file formats and file structures, you can leverage the following to design a SSIS package: