[SOLVED] An additional language can be added to the OS, without changing system default.

Then the correct locale can be selected in the souce connection and it takes care of nasty...

SSIS will provide the process for the import.

Should you wish to call this from a user interface, SSIS package can be deployed to a server and user application can call...

If only logins then login auditing is sufficient.

I believe it is held in the sql logs, which are rotated and a new one created every time sql is restarted, so...

I believe you can set the types during the running of the wizard steps.

If the files are text files with no headers then you could possible concatenate them all into...

Some more testing.

SELECT case when '²' COLLATE SQL_Latin1_General_CP1_CS_AS = '2' COLLATE SQL_Latin1_General_CP1_CS_AS then 'yep' else 'no' end

SELECT case when '²' COLLATE SQL_Latin1_General_CP1_CI_AS = '2' COLLATE SQL_Latin1_General_CP1_CI_AS then 'yep' else 'no'...

Thanks for the answers, the collation sounds good.

Is there a reason why Latin collation show both of these value as equal or is it 'just because'? 😉

You could set up the SSIS task to use a for-each loop take data from a set location (wherever the file is dumped to) on a regular basis.

After processing is...

From memory an excel connector will link to a sheet (unless you wish to programatically loop through them)

If Sheet1 goes to TableA, Sheet2 TableB etc... then I'd be inclined to...

If you can guarantee that to be the case then yes.

SELECT ITEM, REV, DATE

FROM table1

INNER JOIN

(

SELECT ITEM, MAX(REV)

FROM table

GROUP BY ITEM

) AS table2

ON table1.ITEM = table2.ITEM

AND table1.REV =...

Excel tries to be clever and will base formatting on a sample of the records it sees up-front.

If you want explicit formatting then some programming may be required.

There was a...

It may be that SSRS has a property that allows it to recognise CR/LF, which would be the easiest way.

Other than that, it's a case of 'messily' combining results then...

Need a teeny bit more info...

Can't help but think you're making things difficult for yourself.

Doing everything in a single tab would need some programming to work out where the first set of data ends and...

I assume you mean one resultset to each worksheet?

If so, you can set up the Excel destination to explicitly copy to a named worksheet; you would need three Excel destinations