SQL Overview Part 1

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » SQL Overview Part 1

56 posts, Page 6 of 6

«««2 3 4 5 6

SQL Overview Part 1

Rate Topic

Display Mode

Topic Options

Author

Message

SQLdba-473999

Posted Thursday, February 04, 2010 2:41 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 149, Visits: 677

David,
I just had a thought. The servers that are working are running under the default port #, the others that I'm having issues with are not. I tried to connect to a problem server with the port included in Management Studio to make sure I get the string correct before adding to the ServerList table. The string that worked was ServerName.domain.com,Port#\Instance. I added this to the table, but it still errors out! Am I doing something wrong? I feel like this is the smoking gun!

Post #859983

k.przewozniak

Posted Monday, April 19, 2010 7:15 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:02 PM
Points: 51, Visits: 290

Hi,

I have such a problem: In the dbo_SSIS_ServerList I have 236 servers.
Most of the server will through the errors - I know that and I want that, the expected problem is with connection.
When package finishes, in the dbo.SSIS_Errors I have 200 servers and in dbo.Database_Status 15, so 21 servers are missing.
I have already changed the Maximum error count to 99999. but it does not help.

Can you suggest me the solution?

Kasia

Post #905941

David Bird

Posted Monday, April 19, 2010 11:06 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:29 PM
Points: 182, Visits: 952

MaximumErrorCount is set for each container. For example Populate ADO Variable is set to 1 because if it can't set the variable there is no reason to attempt the other containers. Most of the remaining containers are set to 999.

If your MaximumErrorCount is set correctly for all containers, you can try running the script for just the just the servers you are missing and maybe find out why they are missing.

You can also run two two copies of these packages, with each one processing a separate list of servers

David Bird

My PC Quick Reference Guide

Post #906182

optradba

Posted Thursday, February 17, 2011 1:06 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:20 AM
Points: 584, Visits: 854

I tried to set this application up in a 64-bit environment, but I ran into this error below, which I did not get when I previously set this up in a 32-bit environment. Any tweaks that you guys have made to make this run in 64-bit?

[OLE DB Destination [1015]] Error: SSIS Error Code DTS_E_OLEDBERROR. 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_SQL_Servers'. Cannot insert duplicate key in object 'dbo.SQL_Servers'.".

Thanks in advance.

Post #1065472

GAF

Posted Tuesday, July 05, 2011 10:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:05 AM
Points: 34, Visits: 257

Thank you David Bird -- it's a job well done!!

Works like a charm running against 103 active servers/1046 databases....

Looking forward to Parts 2 and 3.

Post #1136650

netra26

Posted Thursday, May 10, 2012 4:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 9:26 AM
Points: 4, Visits: 361

Hi,

I'm trying to create this SSIS package I can definately get the server info for all the server which are on windows authentication however I can't figure out how to get the server info for the servers which are on different domain and are using SQL authentication. Any suggestions please?

Regards,
Netra

Post #1297730

« Prev Topic | Next Topic »

56 posts, Page 6 of 6

«««2 3 4 5 6

Permissions