August 28, 2012 at 11:13 am
failure inserting into id column,oledb destination .
help??????
August 28, 2012 at 11:22 am
It probably means you're trying to insert an explicit value into an ID column, without turning on Identity Insert first.
Without seeing the definition of the destination table, and the insert statement, I can't help beyond that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 28, 2012 at 11:30 am
please provide more detail where and what scenario you are getting the issue...
August 28, 2012 at 12:09 pm
from oledb source to multitask to oledbdestionation in data flow task.
i am getting this error on OLEDB Destination
August 28, 2012 at 12:22 pm
harri.reddy (8/28/2012)
from oledb source to multitask to oledbdestionation in data flow task.i am getting this error on OLEDB Destination
Hate to say it, but mud is clearer. I can't even give you a shot in the dark based on your posts.
Ask yourself, "Self, if this is all I have been given, could I solve the problem?" You at least have access to the SSIS package and the database to be able to look at what is going on.
August 28, 2012 at 12:23 pm
harri.reddy (8/28/2012)
from oledb source to multitask to oledbdestionation in data flow task.i am getting this error on OLEDB Destination
As others have already stated, you need to provide more details. What is the error message? What do the tables look like?
What you have asked in here is like taking your car to the mechanic and telling them "it's broken" and walking away. The mechanic is about as likely to work on your car as anybody here is going to work on your issue.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 29, 2012 at 8:35 am
guys,
i want to know when i place my cursor over , OLEDB destination, there is an error symbol.
and the message is "truncate may occur due to column ."
how can i remove this error.where is the proeprties?
please help me
August 29, 2012 at 8:40 am
harri.reddy (8/29/2012)
guys,i want to know when i place my cursor over , OLEDB destination, there is an error symbol.
and the message is "truncate may occur due to column ."
how can i remove this error.where is the proeprties?
please help me
Well you have gone from "my car doesn't work" to "it makes a noise". You need to think about the fact that nobody over the internet can see your screen and we have no idea what you are working on.
From the incomplete and inaccurate error message it might be that you have data size mismatch. In other words, your source table might have a column with 20 characters and your destination column is only 15. You can't "fix" that with properties. You have to fix the underlying tables. Either make the source smaller or the destination larger.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 29, 2012 at 9:41 am
thanks sean, do we have any truncate properties in ssis,with OLEDB destination?
August 29, 2012 at 10:05 am
harri.reddy (8/29/2012)
thanks sean, do we have any truncate properties in ssis,with OLEDB destination?
You can't "fix" that with properties. You have to fix the underlying tables. Either make the source smaller or the destination larger.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 29, 2012 at 11:14 am
You could use a derived column to create a clone field of only the size appropriate so there would be no truncation.
Just use substring, start at 1 and create a new field. I generally name mine something like MyField_short so it's clear when I get to mapping which to use.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply