Ells (3/6/2012)

---

Guys,

I have normally worked by myself and when it comes to protectio level for the packages I have opted for Encrypt sensitive with User Key.

However when I open someone...

I bet you it will 😉

The only thing left to do is for you to implement, test and provide some feedback of your success.

Divine Flame (2/24/2012)

---

I am thinking of something like this:

IF OBJECT_ID('tempdb..#MyTestTable24Feb2012') IS NOT NULL

BEGIN

DROP TABLE #MyTestTable24Feb2012

END

CREATE TABLE #MyTestTable24Feb2012

(

ID INT IDENTITY(1,1),

Value VARCHAR(20)

)

GO

INSERT INTO #MyTestTable24Feb2012 VALUES ('Param1')

INSERT INTO #MyTestTable24Feb2012 VALUES ('Param2')

INSERT INTO #MyTestTable24Feb2012...

Not sure...I guess it depends on exactly what you are trying to do. How are you envisioning the use of dynamic sql...

stephen99999 (2/24/2012)

Most definitely makes sense. At least that way, we would only be generating the City data one time vs. 10 times. I could even still end up using an...

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