Really - OK, use a Script Task.

Here's some code:

Public Sub Main()

'

' Add your code here

'

...

Is your requirement to move data or to move schema info (or both)?

Why not just use a straight UNC path?

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...