tripri (9/9/2011)

---

Hi,

I got different packages which are running fine. But now i got issue with one newly designed package whihc will update two columns in a table with the values...

chris.stuart (9/9/2011)

---

Thanks for starting me off in the right direction, however

On both PC and Server, the regional settings is set to English South Africa. If I look at the report...

venus.pvr (9/9/2011)

---

Martin,

Even string wouldn't work(cannot convert between unicode and nonunicode string error). Staging the data as is and then converting using data conversion would work. You are correct, I should...

venus.pvr (9/8/2011)

---

Martin, thank you for the response.

I wish I could do something to prevent something rather than waiting for an error to occur and then fixing it. It becomes tough...

venus.pvr (9/8/2011)

---

All,

I have a column in oracle db sit_id which of NUMBER datatype of lenght 22. SSIS reads it as unicodestring of length 38 in the source. I get...

dndaughtery (9/8/2011)

---

I have a pkg where I want to call it and set the value of its global ssis variables with values passed in as parameters from the call. How...

chris.stuart (9/8/2011)

---

Hi All

I'm having a problem with regional settings in SSMS. I'm creating reports in SSMS which pulls the data from my server. On my PC the settings are set...

Rem70Rem (9/7/2011)

---

When I remove the primary key on my destination table, the execution time is decent. I need to have this for performance issue. This is my fact...

Interesting question, and BOL politely avoids being specific (http://msdn.microsoft.com/en-us/library/ms179917.aspx)

I guess you will have to assume that in the case where the IsTransferASCII property is set to false, no command will...

The short answer to your question is yes...there are a few alternatives. If you are...

thang_ngo_2002 (9/3/2011)

---

I have an alert system based on SQL Server

When I use SQL 2000, I monitor an Oracle system by SQL DTS, DTS contains 1 transform "select 1 from dual"...

You can choose to ignore all truncation errors (in the error output), but you would still have to do this for all source columns and IMO it is a very...

GSquared (9/2/2011)

---

It's adding a number of weeks (ColC) to ColA, until ColA is caught up with the current date.

So, if ColA started out as a year ago, and ColC =...

On face-value, it seems like the while-loop will only be executed once...unless there is something else that happens between the update (maybe triggers) and the select inside the loop.

Not sure...

If-statements in queries could cause some sub-optimal execution plans. See the following for reference: http://sqlinthewild.co.za/index.php/2010/12/14/do-if-statements-cause-recompiles/

My suggestion would be to have separate procs if the queries are that different and it...