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.

Create an integer package variable (scoped...

What provider did you choose and what error message did you get? Please copy/paste the exact text.

Four hours, that's harsh. Post back if you have any questions about coding in the script component. As an Informix guy, this is a bit of a change for you,...

bhavika.chauhan (4/15/2011)

---

I have to import data from Excel to Database .

In between that i need to check several validations such as duplicates, Distinct rows , quantity cannot be negative etc...

Oh yeah! My weekend started early when I couldn't get to work today (not my fault) 🙂 Haven't quite made it to the pub yet, but the beer is getting...