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 known probs SQL2000 und Server 2003

Hello out there,
we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
not to do so? Anything, we should be aware of?
Thank you!
Bernd
We moved dozens of servers with no problems.
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:Op1fE1SHEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Hello out there,
> we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
> not to do so? Anything, we should be aware of?
> Thank you!
> Bernd
>
|||If you use distributed transactions - it needs additional configuration.
If two are not in same domain you need to disable rpc security.
I cannot remmeber links now - search MS KB.
Bojidar Alexandrov

Any known probs SQL2000 und Server 2003

Hello out there,
we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
not to do so? Anything, we should be aware of?
Thank you!
BerndWe moved dozens of servers with no problems.
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:Op1fE1SHEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Hello out there,
> we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
> not to do so? Anything, we should be aware of?
> Thank you!
> Bernd
>|||If you use distributed transactions - it needs additional configuration.
If two are not in same domain you need to disable rpc security.
I cannot remmeber links now - search MS KB.
Bojidar Alexandrov

Any known probs SQL2000 und Server 2003

Hello out there,
we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
not to do so? Anything, we should be aware of?
Thank you!
BerndWe moved dozens of servers with no problems.
"Bernd Maierhofer (dato)" <bernd.maierhofer@.dato.at> wrote in message
news:Op1fE1SHEHA.3444@.TK2MSFTNGP11.phx.gbl...
> Hello out there,
> we plan to move our MSSQL2000 database to a Win 2003 server. Any reasons,
> not to do so? Anything, we should be aware of?
> Thank you!
> Bernd
>|||If you use distributed transactions - it needs additional configuration.
If two are not in same domain you need to disable rpc security.
I cannot remmeber links now - search MS KB.
Bojidar Alexandrov

Any good books on Microsoft Reporting Services for a Visual Studio developer?

I'm starting to useMicrosoft Reporting Services and coming from a Crystal background. I'm wondering if anyone is aware of a good book that addresses development of Microsoft reports within the Visual Studio context.

Thanks!

BCB

I just ordered Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson through amazon this morning. It is supposed to be here tomorrow sometime. I can let you know if it is any good. It did get good reviews on the amazon site and I also found amazon to be the cheapest.

I am having problems with my reporting deployment to the server. It keeps telling me that the ASPNET account does not have sufficient privileges to perform the operation.

|||I have been using Brian Larson's book (SQL Server 2005 Reporting Services) for several months and it is wonderful. It reminds me of a good Wrox book in the sense that it uses cumulative examples where a report that was developed earlier may be used as the basis for demonstrating a new feature. (Don't get me wrong - there are a bunch of report types in the book including Web Services.) You can work through the examples yourself or there is downloadable source code. The book covers both the design and administration side of Reporting Services. The book is less than 600 pages (not counting the appendices) and it has many screen shots that make explicit what the author has just described in words. I like that. The examples really work and files that he references are present in the folders where he states they will be found. I like that even more. Larson isn't just a technical guy who knows a lot about this product; he's an accomplished writer as well. I found that the book was a fairly quick read that managed to leave a lot of knowledge behind after I put it down for the final time. Did I mention that I recommend it?|||Hey guyin kalamazoo,

I just recently went through this learning curve. You have to add permissions for ASPNET to the database that the datasource is trying to access. Unless you store the credentials in the datasource, then it will use those credentials to access the database.

Anyway, look into the permissions for ASPNET on the machine with the database, and make sure you have the proper roles setup on the reporting server.

I hope this helps, as I am still relatively new to SSRS2005.

Anthony

Anti virus on a failover cluster

Are there any cluster aware anti virus products that dont cause problems
such as the ones outlined in KB250355
http://support.microsoft.com/default.aspx/kb/250355 ? I dont want to run
with no anti virus. Thanks
AV products use filter drivers that intercept traffic on the server. You do
not want this on a DBMS server because of the performance overhead
associated with it.
What you can do is use the scheduled file scanning tools that come with most
AV software, but you should disable any ACTIVE SCANNING functionality.
More importantly, DBMS systems should be highly protected by proper
perimeter defenses, VLAN ACLs, and IPSec policies. Short of the necessary
management functions, the only traffic should be the DBMS TCP/IP
communication.
As such, there should be no publicly available network shares. Any email
usage should be strictly outbound SMTP.
The server should be locked down from any Anonymous access.
Therefore, there should be little need for AV software at all on a properly
configured host. Periodic file level scans should be sufficient to properly
protect the system.
Sincerely,
Anthony Thomas
"Enghps1" <jamesserjeant@.blueyonder.co.uk> wrote in message
news:%23HXMOa%23CHHA.572@.TK2MSFTNGP03.phx.gbl...
> Are there any cluster aware anti virus products that dont cause problems
> such as the ones outlined in KB250355
> http://support.microsoft.com/default.aspx/kb/250355 ? I dont want to run
> with no anti virus. Thanks
>
|||Today every machine should have anti virus software, its foolish not to.
Just exclude the DB, logs, and MSCS directories from your scanner. If you
have MSDTC installed, exclude that folder too.
Rodney R. Fournier
MVP - Windows Server - Clustering
Internally Caffeinated MCT
Windows 2000/2003 MCSE: Security/Messaging
MCSA 2000/2003: Security/Messaging
MCSE + Internet (NT 4.0), MCSE 3.5
HP/Compaq AIS-ASE, CTT+, MSS, LCP
A+, Network+, Server+, i-Net+, Security+
And Great Guy
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Enghps1" <jamesserjeant@.blueyonder.co.uk> wrote in message
news:%23HXMOa%23CHHA.572@.TK2MSFTNGP03.phx.gbl...
> Are there any cluster aware anti virus products that dont cause problems
> such as the ones outlined in KB250355
> http://support.microsoft.com/default.aspx/kb/250355 ? I dont want to run
> with no anti virus. Thanks
>