Whoops, I didn't notice that you were in the SSIS forum - I gave you a T-SQL solution.

I'll have to let someone that knows SSIS better answer this.

declare @CRLF = char(13) + char(10)

set @YourString = replace(@YourString, @CRLF + @CRLF, @CRLF)

I outline my favorite way in Using XML to Enhance the Performance of String Manipulations[/url].

Cynthia DuBose (6/11/2009)

select

[ZIP] = replace(left([CAD3],6), ' ', ''),

[City] = substring([CAD3], 7, len([CAD3]))

from crm5.CAD3

Grant Fritchey (6/11/2009)

WayneS (6/10/2009)

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the...

Gail, thank you for jumping in and answering this for me. You knowledge of how indexes work far surpasses mine.

I assume you have data like:

declare @test table (colA int, colB varchar(50))

insert into @test

select 1, 'plain text' union

select 2, 'csv,data,in,this,row'

select * from @test

A properly formatted CSV file is not just...

You might also want to check the port. The default port is 1433, but you might have changed it during the installation. Or, the previous installation might have been different,...

This might help you out.

http://www.lmgtfy.com/?q=sql+server+2005+move+tempdb+site%3Amicrosoft.com

Cynthia DuBose (6/10/2009)

jain_abhishek (6/11/2009)

Yes

Nick Beagley (6/10/2009)

From SQL2008 BOL: http://msdn.microsoft.com/en-us/library/ms175010.aspx

Queries that modify...

Lynn Pettis (6/10/2009)

WayneS (6/10/2009)

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the...