Anyone is aware of this SSIS Error.

Hi Folks,

I developed my ssis package against my local database and i would like to test it against remote server database.For that i have modified all of my connection manager settings still i am getting error on oledb destination and Execute T-Sql task.The below is the error.

[OLE DB Destination [11665]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__tblPr__532FC765'. Cannot insert duplicate key in object 'dbo.tblPr'.".

Can anyone suggest me what would be the problem and how to resolve this.

Thanks in Advance.

Violation of PRIMARY KEY constraint 'PK__tblPr__532FC765'. Cannot insert duplicate key in object 'dbo.tblPr'.

This means you are trying to insert a key which is already in the table tblPr. Primary Keys have to be unique.. to identify a specific row.

for example (ID is your Primary Key):

ID | SomeColumns
1 | test
2 | testasdf

and now you are trying to insert

1 | anothertest

the column ID (which is your primary key) has already a row with 1 so you can't insert a second row with ID 1

this is just an explanation of your problem .. but i can't help you without any further information... maybe you can fix it on your own when you understand it

- paul
|||

Hi Paul,

I made the changes It works now.Thanks.

I am getting one more error when i am executing Execute T-sql Task.I am using identity column in my tsql statement.

Below is the error.

"User 'guest' does not have permission to run DBCC CHECKIDENT for object '#TempPr__000000000ACC'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Please let me know what is wrong if you know..

Thanks so much.

|||

A search on the Internet will yield very helpful results. This is a permissions issue, just as the error says.

Read up on DBCC CHECKIDENT.

http://msdn2.microsoft.com/en-us/library/ms176057.aspx

any other plugin algorithm developed?

hi,

as we know we get clustering algorithm with managed plugin algorithm API

does anyone have developed any other plugin algorithm as i want to check what are the things that needs to be modified. i am not data mining algorithm developer but i just want to check where we have to make changes. i would be better if i get source code for algorithm other than clustering

ANOTHER PLUGIN ALGORITHM REQURIED?

thanks in advanced

We haven't made any other samples available as of yet. Angoss and KXEN, among others, both have implemented plug-in algorthms that they sell commercially. I don't know of any parties that have made source code available for their plug-ins - maybe someone will start?|||

is it possible to get detailed class diagram of DMPluginwrapper?

because i want to understand it in detail, as i want to implement framework in c# (totally) but before that i want to understand current architecture in detail.

|||

All the classes in the DMPluginWrapper are fully documented in the CHM help file that is included in the sample. Is there something missing from that?

A diagram of the interactions (in the COM system) for DM plug-in algorithms can be found here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/ssdmpia.asp

I think I mentioned before, I am not sure what kind of benefits can be obtained from re-implementing all the framework in C#. The COM interop layer must be there, anyway, and whether it is developed in C# or managed C++, the differences are just syntax elements.

Also, related to your initial question: I have developed a few different (incomplete) algorithms using the framework. Typically, a predictive algorithm (such as a classification or regression solution) requires a subset of the features included in the sample for the clustering algorithm. The cluster specific features are:

- CaseLikelihood and Clustermembership (in the algorithm class)

- the "*Cluster*" functions in the list of standard supported functions of the Metadata class

- the Cluster viewer in the Metadata class

If you remove these, your algorithm is not a clustering algorithm anymore. However, the remaining code should be enough for classification, regression or association types of algorithms. Of course, you will still need to implement your own training and prediction mechanism (specific to your algorithm)

Hope this helps

Any advice on testing Data Warehouse solution?

We are looking at deploying a data warehouse solution soon that has been
being developed for a few months. The development team has been working on
developing this for the company. Soon they will be turning this over to the
DBA group to do some level of integration testing with the rest of our
production data.
What guidelines are there for testing data warehouse solutions?
What types of things should I be looking for other than user sign off that
the data looks good?Function test of Backup/restore of full data size
Performance/Load testing of full data size
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Doug Needham" <dneedham@.cfsloans.com> wrote in message
news:eqTaIH3xDHA.2148@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We are looking at deploying a data warehouse solution soon that has been
> being developed for a few months. The development team has been working on
> developing this for the company. Soon they will be turning this over to

---

the

quote:

---

> DBA group to do some level of integration testing with the rest of our
> production data.
> What guidelines are there for testing data warehouse solutions?
> What types of things should I be looking for other than user sign off that
> the data looks good?
>
>

---