You can use SSIS for this you will need to setup an excel data source then use a task to split out the data to the correct destination table.

You will...

what is the reason ? i am just curious at it seems that it is...

Why can't you extract straight from the database using SSIS? this would allow you to use a sorted query for your data source..

If you use the replace command in your select query then this will not affect your data at all..

Add the replace into your code that you have and...

try using REPLACE to search for two double-quotes and replace them with one double-quote

SELECT REPLACE('"OBS""','""','"')

it should be fairly simple, if you post your table defs and some sample data then i am sure someone can help.

How are you running your SSIS packages?

have you deployed them to the files-system or database?

use CAST to convert the data types,

SELECT CAST('1500.000000' AS NUMERIC(18,2))

I would load the data from the files into a table, then use a sql task to create some indexes on the tables, and then join them using the...

try this code, it should work fine, but you may need to change it slightly if you dont want the single unique rows to be numbered

UPDATE [YourTable]

SET [LicenseNumber] =...

I did something like this recently and tried a few approaches but eded up using LogParser, its a free tool from microsoft that reads log files and can output them...

have a look at your execution plan and this will give you a clue where the bottlenecks are and help you pick the correct index.

Is there a reason you are...

What indexes do you have on the table.

Also use

select count(*) from Table1

if you want a row count as this allows the optimizer to pick what is...

I would...

Can you post the query?