Thanks guys.Works like a charm now 🙂

No ideas from anyone?

Thanks man.

You are the man;-)

Thanks Koen.

Can you send me examples of using power viewer

Thanks

But are you saying I should just use data conversion for every column?

If I knew the column causing the error .yes

Cheers

Tried that and no error but the data in the colum didn't export.

But usin Derrived column and converting to DT_WSTR worked

Can anyone help??

Sharepoint BI is def one of the best.

With SQL server 2008 R2 and Sharepoint 2010 you get alot though.

if you need more info let me know.

Patrick

Gah,

I was thinking about this method already if i decide not to use SSIS. 🙁

By the way my records could be over half a million records.

Thanks.

Check the comments below after the post. One of the approaches mentioned is this:

"Use the OLE DB Command to do the updates, an OLE DB Destination to do the inserts."

Yes...

Thanks and i'm following this article

http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

I have added a

Lookup -- i use this to redirect rows if there is not match

and a

Conditional Split component.-- using for...

After trying the below i get error:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "problem_log_notes.log_notes" could not be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier...

Gail rowid or lognotedate

my SSIS package is deployed in a SSIS package store. e.g samplle.dtsx

Thanks

--------------------------------------------------------------------------------------

These are actually 2 questions. I would suggest that you post the second question in a separate message thtread.

Can...