I think you're confusing the way data should be stored internally with how it should be presented to the users.

It's not a conversion issue, it's just how you format data...

What are you referring to?

I initially posted a...

To get rid of the lazy pool you should alter the function WITH SCHEMABINDING.

As a side note, using functions in join conditions is not a good idea at all.

Hope...

I suppose you're not running this query on a SQL Server 2008.

I think you're on SQL Server 2005.

Deadlock priority can be set at session level with SET DEADLOCK_PRIORITY, or can be determined automatically by the sql engine calculating the cost of the rollback for each process involved....

Doh! Now I see what you mean. Sorry for misunderstanding.

I don't see a question here... can you explain?

Try tracing it with a server side trace.

Select at least statement completed, stetment starting and user error as events and set up a filter on application name=SSIS.

This should help you...

Paul White NZ (6/29/2010)

---

The thing that has sucked most (so far) about the World Cup, in my view, is not the refereeing or the vuvuzelas - it's the players. ...

I had to face the same problem and it's not so easy to solve with SSIS, so I decided to use .NET code.

I'm no SSIS guru, so probably there's something...

Ooops! You're right, sorry for the bad advice.

Try sorting using the numeric part only:

select top 1 @num = num from table order by right(num,len(num)-4) desc

That's what I was...

Use UNC paths:

\\yourcomputername\sharename\filename.csv

Bulk inserts use delegation, so make sure your share can be accessed by the user that performs the BULK INSERT command in SQL Server.