Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

error Expand / Collapse
Author
Message
Posted Tuesday, August 28, 2012 11:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
failure inserting into id column,oledb destination .

help??????
Post #1351132
Posted Tuesday, August 28, 2012 11:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:50 PM
Points: 13,872, Visits: 9,598
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
Post #1351141
Posted Tuesday, August 28, 2012 11:30 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, October 10, 2014 2:48 AM
Points: 723, Visits: 352
please provide more detail where and what scenario you are getting the issue...
Post #1351146
Posted Tuesday, August 28, 2012 12:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
from oledb source to multitask to oledbdestionation in data flow task.

i am getting this error on OLEDB Destination
Post #1351167
Posted Tuesday, August 28, 2012 12:22 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:32 PM
Points: 20,799, Visits: 32,718
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1351175
Posted Tuesday, August 28, 2012 12:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:31 PM
Points: 13,207, Visits: 12,688
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1351177
Posted Wednesday, August 29, 2012 8:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
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
Post #1351667
Posted Wednesday, August 29, 2012 8:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:31 PM
Points: 13,207, Visits: 12,688
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1351671
Posted Wednesday, August 29, 2012 9:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
thanks sean, do we have any truncate properties in ssis,with OLEDB destination?
Post #1351724
Posted Wednesday, August 29, 2012 10:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:31 PM
Points: 13,207, Visits: 12,688
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1351745
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse