If all you are doing is a table dump, there is no reason to use an index.

And, no, there is no way that I know of to improve the performance...

A flat table is fine for storing more than a million records.

However, if you find that there are a some columns with a lot of empty rows, it may not...

SreenivasaRao:

Update

   MyTable

Set

   RANK =

      (

       Select

          (Count(*) + 1)

       From

          MyTable t2

       Where

          t2.MARKS > t1.MARKS

      )

From

   MyTable t1

sql_2005_fan:

It means you are looking for an amount from "bills a" for which there are exactly 3 amounts which are higher in "bills b".

This means that you are looking for the 4th highest amount...

Bill,

I doesn't look like your company already has a standard for date format.

Personally, I prefer yyyy-mm-dd, since the date parts are easily distinguishable, and it simplifies sorting.

Jon,

Evaluate means to process the Object_Name() function and get its result.

Hank,

The properties you listed are the Connection Properties, not the OLE DB Properties.  Thank you, but I already know how to access the Connection Properties (see original post).  What I am...

Object_Name() returns a character string.  The From clause requires an object.

Let's say that @Object = MemberTable.  If you evaluate Object_Name(MemberTable) and stick it into your select statement, you get:

select @pendT = count(*)...

OK.  I can see now that I was so used to using queries to return matched records that I was thinking of this query in the same way.  But it...

It turned out to be a table that got corrupted after a new column was added to it.

ghughes,

set @query = " select Source='IMS Issues Segmentation Percentages',@total4 as GTotal, @hits4 as GHits, (@hits4 / @total4) as Hit_Percent "

should be:

set @query = ' select Source=''IMS Issues Segmentation Percentages'',@total4 as GTotal,...

ghughes,

If you need to put a single quote in your string, simply use two single quotes in a row.  For example (and those are not double quotes, those are two single...

OK.

But, you don't need to execute a dynamic properties task.  You can instantiate the task which does your bcp'ing and then set the properties for the task using the instiated object. ...

Mark,

You are not executing anything from inside the loop.  By setting the execution status of stpExport to "waiting" you are merely saying that stpExport is waiting to be executed after the current...

Brian: "The only other thing to do is key off of the servername or some other flag and then have a conditional execution of code."

That's exactly what I am talking...