to replace this default dialog please handle the dataerror event

Question

Hi !

I am getting the above error while exploring data from DSV from within SSIS project.

I am trying to explore data from Adventure works 2008 R2 DB's table 'Employee' .. It gave me a long error along with the message 'to replace this default dialog please handle the dataerror event '

Its a sample DB , why am i getting this error ??

Also please let me know how to overcome this error ?

THanks !

---

--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Answer 1

Could you please provide us with the actual error?

Answer 2

Could you please provide us with the actual error?

this is the complete error,

---

--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Answer 3

What are the column types in your datatable?
Do you have varbinary data? If yes, change it to binary.

Answer 4

What are the column types in your datatable?
Do you have varbinary data? If yes, change it to binary.

But the columns are from Adventure Works 2008 R2 sample database. I am taking directly from the table and not querying it..in this case i am not ablt to see the place where i can change the data type.

Also, i got this error from DSV which has contained only one Employee table and on exploring the data i got this error.'

In case if it is within the dataflow task would take data conversion... here how can i go ahead with the data type change ?

Request you to kindly let me know.

THanks in advance !

---

--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Answer 5

Right. Do you get the error for other databases?

Did you try to create another project and see if the error occurs.

Answer 6

Hi Radhai,

A data source view is built on a data source. Therefore, before you can use a data source view in a package, you must add the data source to the package. What type of connection manager you are using? You can change data types using Data Conversion Transformation, please see: http://www.bimonkey.com/2009/06/the-data-conversion-transformation/

Thanks,
Eileen