Hi Luis,

Quick question, are you using any function here?

SELECT *

FROM Delimited

CROSS APPLY dbo.DelimitedSplit8K(String, ',');

If yes, could you please post this function as well....

Thank you for your help!

Here I update my sample data

LAT|BOX|5290113661|BP9744524|PHY|JAI|GREWAL|1|BI|VaccBill|MED|191.2||SHI||20131015|50242

06001|||||6|116820411||

LAT|BARDI|TAMMY|20020 44th|PHY|MARK|MORADI|BI|Vacc Bill|MED|183.0||SHI||20131016|50242006001|||||6|116899590||

LAT|ARRE|SONIA|344 RICH|PHY|IAN|HANT|1|BI|Vacc Bill|MED|153||SHI||20131016|50242006|||||3|116786607|

AND I want to be my out put in Flat file like this.

LAT|BOX|5290113661|BP9744524|

PHY|JAI|GREWAL|1|

BI|Vacc Bill|

MED|191.2||

SHI||20131015|50242006001|||||6|116820411||

LAT|BARDI|TAMMY|20020 44th|

PHY|MARK|MORADI|

BI|Vacc Bill|

MED|183.0||

SHI||20131016|50242006001|||||6|116899590||

LAT|ARRE|SONIA|344 RICH|

PHY|IAN|HANT|1|

BI|Vacc Bill|

MED|153||

SHI||20131016|50242006|||||3|116786607|

Here I want, Split...

Awesome!!!!

This question is ANSWER....

I am thinking, how I about I rename a file from txt file to FileName.bak, would that be good?

Here is the Sample Data

ID,DISTRIBUTOR BCITY,ACCOUNT ID TYPE,ACCOUNT ID

DS,BP9744524,CARLSBAD,D,BR9307299,UNKNOWN

I can Open this .DAT file in Notepad. Client just want above format files in .DAT format.

Please guide me or you...

Yes 98% same except

-- Raise an error and return

RAISERROR ('Error in SP.', 16, 1)

RETURN

Thank You For your help!

Is this looks good to you?

Alter MYSP

Begin transaction

Begin Try

1st Insert Statement

2nd Insert Statement

1st Update Statement

commit transaction

end try

begin catch

rollback transaction

-- Raise an error and return

RAISERROR ('Error in...

My question was, How I can you RollBack Sql Syntax, Here is a E.G

Alter MYSP

Begin Tran

1st Insert Statement

-- Rollback the transaction if there were any errors Start

IF...

Jason, Yes For sure its a SQL File "Save as type" (Good catch)

I tried to force to save in .sql but still saving in .txt file..., you are right i have third party software "ApexSQL" in my machine.. I am going to...

Thanks, that was I was thinking....

I am thinking how about If I get Recent file name from folder?

Is anyone can please guide me how i can recent file name from...

In FileSystem Task I am Renaming file name, FileName_GETDATE(), so you are right file name gonna change. Here is the thing and I am not sure why its happening. When...

Hi Guys,

Thank you all for your help. I used RowCount Tranformation...

One more question, I want to display Count and file name and put in to flat file. I got...

Yes I got it. Sorry or confusion, Thanks Guys.

Yes you guys are right good idea to change D.Type.

Sometime not a good idea to argue with Manager about wrong...

Luiz thank you for your help, however that sql is just for one e.g. How I can use your sql on one column?

Year could be 2013 or 2012 or any...