Gosh I know that's gonna be hard. I thought you just wanted SSIS error code. Well, to do that, you have to customize some codes in the script component according...

VALEK (2/19/2008)

---

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

VALEK (2/19/2008)

---

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

I have been reading this problem and thought it would have ended but unfortunately because of some confusion, nothing is moving I guess. I think the first thing I would...

First of all, where are you getting the file from? Is it from a folder somewhere or is it located in FTP? Because it can be a lot more easier...

I have just finished doing something similar like you. From flat file source, grab the failure precedent constraint (red arrow) and put it in a script task transformation. Then configure...

Not sure what you want to do. But why Parent and child package? Why not everything in one since we have precedent constraints in SSIS? Respecting whatever you are trying...

Thanks Daniel. I certainly will also think about that in fact. I know how database size have made my life hard before. You are right that everything should be set...

By reading your replies, I can understand your problems. Here is two way to get out of this problem.

1. Do as what I have told you before.(OLE DB Source to...

I am assuming that you are brand new for this. I will also recommend a lot of reading. But to...

k (2/12/2008)

---

Hi,

I want to generate CSV files based on location.

i have a location master assume values will be India, US, CA, etc...

based on the location i want to create and...

If you are asked to do different datatype in the destination, i hope you know that the data conversion transformation can do that for you. But the datatype in SSIS...

Ok. I think I see what your problem is. Okay, now, do you have any condition on that specific column? Like should it be null or something. Then just scroll...

kurraraghu (2/19/2008)

---

i have done that but i cpuldnt find any problem any way how should i do that will u plz tell me my data in row 44870 is...

I agree with Jack. Some sample would really help. By the way, here is what I would suggest. I had this same problem long ago when I started using SSIS....