What is the datatype of your derived column?

Yes. If there are hundreds of thousands of records to be deleted, I would recommend that you do the delete in batches to avoid huge transactions grinding your system to...

Where is your source data coming from? A DELETE query (or series of queries, if lots of rows are to be deleted) would be faster.

Then you should forget the Transfer SQL Server Objects task. Look instead at the Data Flow task where (at its simplest) you define a source, a destination and a mapping...

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