Presumably you tried setting the UseInLineSchema property to false?

If you take the time to read through the entire thread, you'll...

If the data might 'come again' after a 'break', why would you want to retain it if it is identical to what has gone before?

vibin.das (7/6/2010)

---

Hi,

I'm totally new to SSIS 2005 and i have been assigned to do the following tasks.

Following is the scenario

1)There will be a root folder say A1 and inside that...

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.