This should do:

RIGHT( FIRST_NAME, LEN( FIRST_NAME ) - PATINDEX( ' ', FIRST_NAME ) ) + LAST_NAME

I just can't recollect now, can you just cross check for the option "TEXT IDENTIFIER" in BULK INSERT?

foxjazz (3/14/2009)

---

yea, you don't need to use a comma as a field separator.

However...

ROW_NUMBER() is what are looking for, Check Books Online for more info..

SELECT ROW_NUMBER() OVER( PARTITION BY Col2 ORDER BY Col2 ) AS SeqNo, Col2

FROM SomeTable

I feel very upset that I don't have any SQL right now:crazy::crying:, Sorry michael:ermm:, you have to wait until Monday if nobody else beat it to me.:D

Jeff Moden (3/14/2009)

---

Just do 3 simple bulk inserts. It's also one of the fastest...

You just need 2 connections & 1 data flow task, within the flow task you will have source and destination components. And in the source, you select SQL command...

See this article on Looping, Importing and Archiving files in DTS Packages using ActiveX Script

I'm glad that it worked out nicely.

Does the queries are part of a procedure/function that were created using RECOMPILE option? This may be causing the server to re-compile every time on each execution.

I'm glad, I could help you.

No, any change in database properties does not require a server restart.

Does the query returns large no. of rows? How much time does it take to execute? How about adding the execution plan as an attachment, so to check for...

Still not very clear, why don't you read this article on how to post questions to get better/quick responses[/url] and help us in helping you.

What errors do you get when connecting to server in your web application?

Can you able to connect to SQL Server using SSMS from application server?

No, the data will not be deleted. The Transform Data task just dumps data from source to destination.