i have an error when i put data in SQl.. and this my fields name data type..

It seems that one of your data are longer than the destination fields. You have to check this.

You probably tried to insert the data by copying and pasting the row, and some if not all the fields got some extra white space at the end which has caused this error. To remedy, go and trim space chars in each field up by backspacing and then step into the next row. * Please note that this is a SSIS forum and your post does not seems relatedArthur My Blog

Ryan9108, There is some column which has exceeded the length so is the error, check other columns as well like names , studentno.. The red colors indicate the data is not committed.Happy to help! Thanks. Regards and good Wishes, Deepak.

thanks sir..can i ask question..all my fields are correct data type??becuase the student number and So No when i user data type of the example int.then i input data student no 20081118765 and the SO No 123456789..the data cannot allow..

You are welcome, Well, the date is represented as a varchar(50) - this is not ideal, but I believe an application is further formatting it to what you need (what I mean is the database does not enforce this to be a valid date, but this sometimes cannot be controlled e.g. when you get dates from another system) so all the numeric fields you store as text, so you probably just ought to get truncation warnings, that's all.Arthur My Blog

Hi Deepak Yes that my error..i already corrected..:)..

thanks sir for the explanation..so that i will understand what kind of data type that i want depends on the fields..thanks again sir:)..this is the perfect forum for me:))