Ed Zann (7/7/2010)

---

Here is an approach you might explore - although I don't know efficient it would be with your volume of data. Also, this assumes that your Subxx...

What exactly do you mean by the word 'excaltly'?

:hehe: just kidding - couldn't resist it.

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: