error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » error

11 posts, Page 1 of 2

1 2 »»

error

Rate Topic

Display Mode

Topic Options

Author

Message

harri.reddy

Posted Tuesday, August 28, 2012 11:13 AM

SSC-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

GSquared

Posted Tuesday, August 28, 2012 11:22 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

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

sandeep rawat

Posted Tuesday, August 28, 2012 11:30 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, May 13, 2013 4:06 AM
Points: 681, Visits: 298

please provide more detail where and what scenario you are getting the issue...

Post #1351146

harri.reddy

Posted Tuesday, August 28, 2012 12:09 PM

SSC-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

Lynn Pettis

Posted Tuesday, August 28, 2012 12:22 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 12:11 AM
Points: 21,602, Visits: 27,431

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.

Cool

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

Sean Lange

Posted Tuesday, August 28, 2012 12:23 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 8,592, Visits: 8,233

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

Post #1351177

harri.reddy

Posted Wednesday, August 29, 2012 8:35 AM

SSC-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

Sean Lange

Posted Wednesday, August 29, 2012 8:40 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 8,592, Visits: 8,233

harri.reddy (8/29/2012)

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

Post #1351671

harri.reddy

Posted Wednesday, August 29, 2012 9:41 AM

SSC-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

Sean Lange

Posted Wednesday, August 29, 2012 10:05 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:34 PM
Points: 8,592, Visits: 8,233

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

Post #1351745

« Prev Topic | Next Topic »

11 posts, Page 1 of 2

1 2 »»

Permissions