I got 3.33 ms on a 32bit OS: WIN XP SP3 / SQL Server 2008 SP1 on dual core machine (Intel T2500).

WIN XP SP3 / SQL Server 2008 SP1 on dual core machine

getdate: 6043 3.3399 & 5957 3.33557

sysdatetime: 1713 15625 & 1789 15625

What is the function of your database: OLTP or data warehouse?

You could use an indirect configuration through an environment variable.

Paul White (2/27/2010)

---

Seriously? That hasn't really been my experience. CASE statements are a great way to avoid using a useful index, of course...

Paul White (2/27/2010)

---

wschampheleer (2/23/2010)

---

What are you trying to do? What is the value of @Col? If you want @Col to represent the name of the column on which to filter,...

keywestfl9 (2/25/2010)

---

i have a package where i pass accountnumber to an execute sql task inside a for each loop and store the result in a package level variable.

i am passing...

Try to create a simple package where you only copy the file (or disable the Execute Package Task). This will already allow you to eliminate some possibilities or point you...

Griffster (2/26/2010)

---

Worked it out through trial and error!!! Worked out that, although the data type on Sybase was Boolean I thought I could map it to bit on SQL but...

I gues your problem is data overflow. What do the formulas in your derived columns look like?

ragie (2/15/2010)

---

HERE'S THE QUESTION: How can I abort/exit the child package as soon as the 'badFile' variable is set to 'True' without aborting the parent package also? As soon as...

I have been using a technique loosely based on this article for several years...

You need to reverse the 2nd and 3rd operand.

Also, I assume that col1 is of datatype DT_STR or DT_WSTR, so...

Yep, that's the one. In the command box...

For the field in question in my data reader > input output properties > external columns, the datatype is already eight byte signed integer (DT_I8). Should I be converting it...