How do you define the word 'duplicate' for your data?

Excel is such a pain to import from that a lot of this validation will probably be done for you, though not in the way you want. Invalid data will...

Alexander G. (7/5/2010)

---

First of all, SSIS is not a component that is supposed to have unser interaction, because it is a server technology, so I would not do this.

If you...

Reverse the string, find the first occurrence in the reversed string and then subtract that from the total string length ...

This might be of interest:

http://consultingblogs.emc.com/jamiethomson/archive/2006/07/11/SSIS_3A00_-Output-a-file-as-a-csv-or-an-XML-file.aspx

Dan.Humphries (6/9/2010)

---

Phil, do you have any additional references added. I tried that back when I was working on my script and that command was not recognized. I suspect...

I just tried with a string (called 'Test') and this works:

Row.Test = Microsoft.VisualBasic.Constants.vbNullString

enis.ertem (6/9/2010)

---

Guys,

Thank you for the useful tips.

CEWII - Is there any way to send me the project file as I can only see the executeable. I want to see...

Wow, terse evaluation :w00t:

So your fields are space delimited and a non-existent date appears as a hyphen ('-')?

You'll have to bring the field in as text and then use a derived column to...

Please tell us what you are trying to achieve and why you are facing these questions. If it's for an examination or job interview, this is not the place.

A script component would also be able to do the job (read the lines, form a single record, then output it).

sachinrshetty (6/3/2010)

---

Hi all,

I found the answer in some blog and here it is

"My answer was always "Set RetainSameConnection=TRUE on the connection manager and set DelayValidation=TRUE on all tasks that use...

I do not think that this is the correct way to set up a transaction for what you are trying to do.

Try removing the BEGIN and COMMIT SQL tasks and...

What is your question?