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 12345»»»

SQL Overview SSIS Package III - Full Package Expand / Collapse
Author
Message
Posted Monday, January 21, 2008 11:40 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 11:09 AM
Points: 185, Visits: 1,034
Comments posted to this topic are about the item SQL Overview SSIS Package III - Full Package

David Bird

My PC Quick Reference Guide
Post #445734
Posted Tuesday, January 22, 2008 8:14 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, January 31, 2011 8:56 AM
Points: 178, Visits: 185
I cannot see the code. Where should the attachment be?
Great article otherwise! Parts 1 and 2 were great too.
Thanks!
Post #445886
Posted Tuesday, January 22, 2008 8:50 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 11:09 AM
Points: 185, Visits: 1,034
The attachment to this reply has been removed


David Bird

My PC Quick Reference Guide
Post #445904
Posted Tuesday, January 22, 2008 9:00 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:10 AM
Points: 31,279, Visits: 15,738
Sorry, my fault. David sent it and I must have forgotten to attach it.

It's there now.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #445915
Posted Wednesday, January 23, 2008 8:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 20, 2014 8:34 AM
Points: 32, Visits: 609
Well now. This is great stuff.

My goal certainly was to allow readers of my original article to modify, extend, enhance and utilize the SSIS package I had put together to collect information about the entire SQL infrastructure. I did not realize the exuberance might lead to reader's own articles based so closely on the original solution.

Glad to see it and this would be my first bibliographical reference in my DBA and writing career for SQL Server.

Of course, I would be remiss if I did not mention that my own enhancements to the solution, both SSIS and SSRS are combined in a follow up article in February 2008 SQL Server Magazine. In the article I cover numerous additions to my original SSIS solution, whose assumed name is now "SQL Snapper" for snapshot SQL Server data gathering and reporting. Sounds a little better than repositories and packages. The enhancements include my own version of disk space monitoring (without the requirement for OLE Automation), security reporting at many levels, and job schedule support for SQL 2000 and 2005. I also expand on connectivity to environments that require SQL authentication and provide many new reports that I use quotidianly.

Rodney Landrum
Author "Pro SQL Server 2005 Reporting Services" (Apress)
Post #446733
Posted Thursday, January 24, 2008 3:25 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, May 22, 2008 2:03 PM
Points: 180, Visits: 35
well done! a new way doing autodba job using SSIS.

thanks for sharing.

jiulu



Post #447231
Posted Friday, January 25, 2008 3:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:38 PM
Points: 18, Visits: 464
Much thanks to Rodney and David!!!
I to am new to SSIS and now see it as a useful tool. Now.. How would I go about using these packages with servers that are on the network but not part of the domain? and to make things more fun each of these other servers use sql auth and have different passwords.
Any help would be greatly appreciated.
Post #447844
Posted Friday, January 25, 2008 6:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 20, 2014 8:34 AM
Points: 32, Visits: 609
Hello dguillory,
Glad you like the solution. I cover SQL authentication for DMZ and such environments in the February issue of SQL Server Magazine. Essentially, it is just creating a new data source and storing the password for the SQL auth account. The trick is with running this under SQL Agent and having the appropriate package protection level set. I typically use store encrypted with user name and let the SQL Agent account service credentials decrypt the package and run successfully.
You will need to add seperate job steps tied to the data source, just dupicates, really, but they will run after the Windows authenticated portion doing the same steps.
Again...thanks for your feedback.
Rodney Landrum
Author "Pro SQL Server 2008 Reporting Services" (Apress)
Post #447893
Posted Friday, January 25, 2008 7:39 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:38 PM
Points: 18, Visits: 464
Hi Rodney
I will watch the mail next week for my magazine and I will look for your book in May.
Thanks for the info and thanks for giving to the community. oh yea... Multi Script is a great tool, I would even come out of pocket myself for that one.
:)
Post #447897
Posted Friday, February 1, 2008 8:41 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 11:09 AM
Points: 185, Visits: 1,034
I found the package was missing the log used file size it was suppose to collect. The value being stored was NULL. It has been fixed in the package attached to this message.

David Bird

My PC Quick Reference Guide


  Post Attachments 
SQL_Overview_Part3.zip (205 views, 89.86 KB)
Post #450548
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse