Simple Recovery it is then...

The issue is that occassionaly developers and other users will load data into database without bulk load or other methods and create large logs. This...

Interesting.... not sure as it seems like it should perform the same action. Per books online I saw this...

A sort column can be specified as a name or column...

Glad the text driver worked, as I said I knew that worked but I thought I had also done it with the excel driver.

You should be able...

I am getting the same error. I thought I had done this before, but it may have been a text/csv data source versus xls. You may be able to...

In SSIS you should have a connection manager to your XLS document. Double click on that connection manager to open it. Click adavanced on the left hand colum,...

Look at the data type for the SSIS component (source output) to see the data type. If you just used the default it probably read the xls data type...

Interesting question, and based on the intial response I am interested in what others say about this because their numbers are higher than i would have guess (I guess I...

I dont believe you can have case insensitive passwords for SQL 2K5. If this is for an application with which you have control of the code then you should...

Use RAISERROR command. There is an option for LOG.

Per BOL:

OPTION LOG

Logs the error in the error log and the application log for the instance of the Microsoft...

Good catch. I agree if its a divisional result then this will pose issues of rounding, percision, etc which will have to be dealt with. I assumed it...

I have seen this done typically in two ways (although I have never done it and can't speak to which is best).

Option 1: Build a table with a...

You should be able to use a case statment in your selct. Something similar to...

SELECT...

CASE KeySORNumber

WHEN '2/2687' THEN 1

ELSE 0 END AS [Column Name],

....

FROM...

The issue is likely with your insert statement. A piece of data in the statement exceeds the column size. So you might be trying to put 40 characters...

In the field you should be able to simply concatenate the data. So something like...

= "coverage type of B" & Sum(IIF(Fields!Coverage_Type.Value = "B",1,0))

Thanks. Looks like this tool should work based on the documentation.