One of my larger concerns here is the prioritization of the suborder within an ID. Unless that's pre-built into the file, this becomes a painful endeavour of conditional logic, and...

The first thing I'd do is use a hex editor to assure myself that I know exactly what the characters are which need to be replaced.

Then use REPLACE as part...

Thanks Craig.

I was basing my recommendation on this article which, now that I look at it, is not quite what is required here.

The sample code in the article creates 3...

LutzM (4/23/2011)

---

@Phil: the way I read it is that the OP needs Excel to add the column names manually and (guessing starts here) will import it into SQL Server based...

JStevenson1 (4/22/2011)

---

I receive semi colon delimited txt file and the column placements/position are always same. Currently, I am having to import it to excel and add column header to each....

Actually, I think there is quite a nice way for SSIS to handle this - using an asynchronous...

Same as what?

To whom are you directing...

Neat.

And there was me trying to find the second occurrence of "\" and SELECT LEFT to that position, dealing with NULLs etc along the way. Not pretty.

bhavika.chauhan (4/20/2011)

---

Hi,

Every time i run my package , i create dome folders dynamically using FST . But i want to maintain a version for it . How can i create...

Who's this Keon then? 🙂

Good luck and happy coding! 🙂

If your data looks like this (for example):

ID, Text, Date

1, Good record, 2011-01-01

2, Bad rec

ord, 2011-02-02

3, Another good record, 2011-01-3

4, A very bad

bad

bad

record, 2011-04-04

You are going to have to pre-process...

There is another way.

Create an Excel spreadsheet which contains only field headings/formatting, but no data. This is your template - put it on a network share somewhere.

Then, rather than deleting...

I just read your original post again and maybe I misunderstood what you are doing.

Are you trying to export to a flat file or import from a flat file?

If you...

Then you are up a certain creek and short on paddles.

As I mentioned, how can SSIS distinguish between an embedded CRLF and an end-of-row CRLF?