You cannot convert it to an int if there are CHARS in the cloumn as well.

FYI, the code for converting to an int is

CAST(YourField as Int)

If am reading this...

Why not? do you have any proof of this..?

Mazharuddin Ehsan (11/27/2008)

You can split the data out into two seperate staging tables, one for Firstname and One for LastName

Then use another dataflow to load these both up and...

yes check that the data types in the views match the data types in the table you are inserting data into.

You may be able to fix this issue in the...

You can split the data out into two seperate staging tables, one for Firstname and One for LastName

Then use another dataflow to load these both up and join them...

It looks like you are inserting a value into a row that is too big,

check that that your input datatypes and size match that of the column they are...

It is hard to say what the problem is with out seeing the procedure that is causing the problems.. Post it here is you want some constuctive help..

I dont really know anything about SharePoint, does it have a WebService that you can call? or can you access the database behined it?

Setting up a web-service task does...

From having a quick look at this a few things stand out as bad performing code;

-While loop at the start, A while loop is not usualy a good idea...

it is in SSIS which is a part of BIDS / VS.NET that is installed with SQL 2005.

have you used SSIS before?

Web Service task is under the control flow , not the data flow, so look for it in there.

It is fairly straight foward to configure just add the URL...

Since you are using SSIS to do the import you are better off using SSIS to do the conversion.

You need to add Data Conversion Transformation between your data...

There is some manual work involved and it is not 100% ideal but i am getting better at using it. I work within an open-source development team and they all...

Yeah I am sure, have been doing it here for the...