First of all, your XML is invalid. There is some garbage...

Not to worry, people. I figured it out myself.

The problem was that in OLAP2000 the default measure of the cube can be either a real measure or a calculated one.

In...

send your XML file here and we will have a look.

bitbucket (2/20/2008)

---

Not a guru but a thought, since you have the column ID (assuming it is the column with the error) use this column Id as a parameter in a...

Not quite. Your method would do file->db or db->file transfer. I need db->db transfer and one of the servers is not M$. Ok. Imagine you have an AS400 box with...

Paul (2/19/2008)

---

Actually what I want to do is export all tables to separate files. E.g. Table1 goes to Table1.csv, Table2 goes to Table2.csv, etc.

I'm actually going to take it a...

This thread is a close duplication of this one

Hey guys! Look here and see that we are discussing the same problem.

In brief -- the element where you want to grab column names is not the one where the...

SQL King (2/19/2008)

That was the function of the red arrow(failure) meaning, if there is a mismatch in datatype, it would take the whole row and put it into the error...

Just to add my 5 cents. The same applies to the destination source errors.

For example you have a table having integer rows, but the flatfile supplies illegal strings.

In this case...

Post the file here which makes the process fail and we might help

Otherwise were just guessing

Not really. Since we don't see your flatfile I assumed that your flatfile is broken right at the end of it, e.g. it does not have enough members to complete...

Interesting thing is that if for example a previous to the last record is incomplete, SSIS would do a weird thing.

(default settings)

So the flatfile below:

SYSDEVICES STATUS,0,0

default disk,1,0

physical disk,2,0

logical disk,4,0

backup device,16,0

serial...

Too easy. The message says exactly what it is -- your last row in the table does not have enough info to complete the final record of the flatfile, which...

Thanx for the help, I am in your boat now 🙂

My job now is to migrate the whole damn thing onto 2005 from 2000. They would not go now for...