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?

Nice solution Jeff - except the priority is supposed to be 1,3,2,4 not 1,2,3,4 according to the orig post, so simple mod required.

--Edit, I was wrong. In the case where...

Does the comments column have a text delimiter? I mean, is it surrounded by quotes, perhaps?

Without this, I cannot see how SSIS could ever distinguish between a new row (CRLF)...

sqlsponge2 (4/19/2011)

---

Hello...

I have an SSIS package that is running that is creating an output file that is to big to read in on a third party system. I am...

--Edit

What does the package do?

If you put a script task as the very first task in the script (and write a log file / database entry) at least you will...

Jeff Moden (4/18/2011)

---

Lisset (4/18/2011)

---

Hi everybody, I has created a user function that replace any digit that don't been letter or number but when appear a number with superscript or subscript(ej:...

You're kidding, right?

Sentence 1 from the link:

How were you going to run the package...

Have a look at the on-line help here.