If you can run something like this, perhaps you CAN find out the collation of the columns:

taken from this link[/url]

USE AdventureWorks

GO

SELECT name, collation_name

FROM sys.columns

WHERE OBJECT_ID IN (SELECT OBJECT_ID

FROM sys.objects

WHERE type...

Ok, so you don't have permission. I was able to add it to my local server and I have just ran a simple test to insert into temp, both my...

Just tried it, seems ok. Don't quote me on this though.

Can you add a trigger or does that consitute "changing the table"?

What about the part where insert/update happens, can you change that and add an OUTPUT clause to them to...

No disrespect but a lot of what you are doing is unnecessary. With many conversions back and forth it is easy to get messy results.

Try this

Create FUNCTION [dbo].[NewFormatFloat](@dIn...

I don't understand what the issue is

declare @f decimal(38,31)

set @f=9999999.123456789012345678901234567891

select round(@f,20)

select cast(@f as varchar(50))

Can you post your function and some sample data? See this link for how to do that:...

This is just a stab at this but I think it is the right direction.

See these links:

SQL Server Data Types

Explanation of Mantissa and Precision

It seems that floats do not have...

Your constraint is

CONSTRAINT [tPickPointD01] UNIQUE NONCLUSTERED

(

[tpphidx] ASC,

[desn] ASC

)

so looks like the update is...

Matt, good point. The approach very much depends on their setup and security tolerance. I used BCP in my more SSIS resistent days.

Front end, can you not copy this file to a seperate folder? i.e create a "processing" folder under your current folder and move file there one at a time and...

David, I have no idea about your issue but would like to comment on SSIS in general.

The learning curve is very steep and painful.

I too was introduced to SSIS...

If I understood you correctly, I have done this by putting the XML file in a table and BCP that out to the file. The directory can be loaded from...

Nice,

Those CTEs are great and this might work better for him since he might not have the rights to modify the tables.

Thanks. I thought about somehow use the OUTPUT on the UPDATE but this seems too complicated for that.

Sounds good. Have a good trip.