stephen99999 (2/24/2012)

---

Would the SSIS for-each loop be faster (theoretically) ?

as for the 2nd sproc (xsp_run_sproc2), it accepts the parameter @value, gathers data from various tables based on @value,...

It's a little difficult to say, because we don't know exactly what that second proc is doing...but my somewhat generic advice would be the following:

I would re-write the second proc...

Griffster (2/22/2012)

---

Would that just be for the large tables i.e. the 250,000, 500,000 and the 900,000 tables or all would you say? I'll have a good read of those articles...

imho 1000 is way too low...depending on available resources, it should be closer to 50,000 or even 100,000.

You will have to play around with these to get it right. Look...

http://sqlcat.com/sqlcat/b/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx

http://sqlblog.com/blogs/kevin_kline/archive/2008/10/09/ssis-packages-need-love-too-er-memory-too.aspx

HowardW (2/22/2012)

---

Check the settings on your OLE DB destination. Remove any value from Rows Per Batch and make sure Maximum commit size is zero.

Also, it might be worth looking at...

Griffster (2/22/2012)

---

Think that's a bit of red herring looking in to it a bit further. I created the main body of the new SSIS 2008 package using the import/export wizard....

Griffster (2/22/2012)

---

I've tried the sql statement approach already unfortunately. I've just tried to run the ssis 2005 package in VS 2008 and it runs the same speed on my PC....

My advice in this situation would be the following:

1. Make sure the delay is not at the source. To test this, remove the pipe between your source and destination and...

dshuler99 (2/21/2012)

---

Hi All,

This is my first post here at SQLServerCentral. I am trying to automate the backup of several files daily. After completing several tutorials, I have run into...

sqlcentral2 (2/21/2012)

---

with this query am getting months only for a single year - 2012 if user selects from

march to dec

i would get

march - 3

april-4

........

till december...

Daniel Bowlin (2/21/2012)

---

If you need all rows for some reason (you have a chart or something else that uses all rows) then a filter as Martin suggests is probably the...

Apply a filter on the table itself?

Martin Thomas-357229 (2/15/2012)

---

I would love to upgrade to 2008!

I have attached a screenshot with some dummy data in it to show the layout I have gone for where the vertical...

Thanks for the feedback. Pity you are not using SSRS 2008, because strip lines (in 2008) would have made it so much easier.

If possible, could you please post a screenshot...