There are two things that could be causing your issue....

Wait... 11 - 13k of RAM? 32-bit?

Where did you dig up this dinosaur? @=)

You are comparing apples to oranges. SSIS is set up differently than SSMS. We advise you hire a consultant to come in and look at your environment to give you...

BWFC (10/18/2016)

---

jasona.work (10/18/2016)

---

BWFC (10/18/2016)

---

jasona.work (10/18/2016)

---

Brandie Tarvin (10/18/2016)

---

What a morning. SSC just broke my heart.

I see an article about time traveling listed in the newsletter. Get ready to read it and...

Do people really not know how to look at their email headers?

I just got an email from someone I don't recognize. So I popped open the message options to...

Here you, Threadzians. Have a palate cleanser.

river1 (10/18/2016)

---

Hello,

The ssis as a loop also. It is a forearm loop container. It loops the same number of times as the sp.

Also, tests are being executed on the same...

BWFC (10/18/2016)

---

jasona.work (10/18/2016)

---

Brandie Tarvin (10/18/2016)

---

What a morning. SSC just broke my heart.

I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's...

Brandie Tarvin (10/18/2016)

---

If I am reading this correctly, you aren't even executing the procs in the same manner in the SSIS...

river1 (10/17/2016)

---

Hello, Thank you for the feedback. Both on same machine. The ssis package performed much better then the script. With the package I take 16 minutes. With the script...

What a morning. SSC just broke my heart.

I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's not talking about building...

No. But I'll give it a shot. Last time I saw behavior like this, it was because SSIS was running on an app server...

Are you actually executing SSIS on the same exact machine / instance in SSIS as you are executing the procs in SSMS?

And, if so, how are you executing SSIS?

Which is...

Ed Wagner (10/17/2016)

---

Phil Parkin (10/17/2016)

---

Brandie Tarvin (10/17/2016)

---

rodjkidd (10/17/2016)

---

So hands up who loves the idea of a production db being called Test_Autos on a server that was the test server...

Yes a...

rodjkidd (10/17/2016)

---

So hands up who loves the idea of a production db being called Test_Autos on a server that was the test server...

Yes a production server details were also sent...