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.

And presumably an integer (given that you are performing maths on it)?

In which case, why not something like:

...

ABCD_Call_ID...

By the way, that query syntax is a little unusual. What does @[User::_FileID] contain?

Create an ExecuteSQL task and use an Expression to define the SQL to be executed - you'll be able to build the expression to include your variables as required.