I have done that using substring function.

Thanks,

PSB

If I use this string below

DECLARE @TestStr VARCHAR(MAX)

SET @TestStr=' 5305 ...

I will confirm that if I can add persisted columns. Can you please explain how to do that ?

I was not the one to create the tables.

It fails with string

5305 ...

Thanks All ! It worked.

I used this SP

ALTER PROCEDURE [dbo].[usp_PreInsertRowCountStaging]

AS

BEGIN

DECLARE @RowCount INT

SET @RowCount = ( SELECT COUNT(*) FROM dbo.Staging WHERE DATALENGTH(TransRecord) != 100 )

SELECT @RowCount AS [RowCount]

END

And then mapped it...

Sometimes I might have this

TRITONRL5000 LRL5114070400714 ...

Thanks. When I execute your query, I get two columns for date and then one for description.

I want just onle column for date. Also I is the character and not...

Thanks. That worked !

Is there any other way to make the flat file name dynamic ? That is not do any of these and just pick up any file...

I have to make the filename for the flat file dynamic of the given format. I will have it every hour. Is there a better idea to do that ?

If you use a XML Sourec editor , you will notice there is a output name drop down in the editor. There you will notice Banking center and AssociateInfo as...

Please help.

Sorry, actually I meant 7.

LEN([Phone]) == 10 ? (DT_STR,12,1252)SUBSTRING([Phone],1,3) + "-" + SUBSTRING([Phone],4,3) + "-" + SUBSTRING([Phone],6,4) : LTRIM(RTRIM([Phone]) worked for me .

Thanks a lot

LEN([Phone]) == 10 ? (DT_STR,12,1252)SUBSTRING([Phone],1,3) + "-" + SUBSTRING([Phone],5,3) + "-" + SUBSTRING([Phone],9,4) : LTRIM(RTRIM([Phone]) is inserting as 803-887-84

instead of 803-788-7884 from the number 8037887884