SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Overview SSIS Package III - Full Package


SQL Overview SSIS Package III - Full Package

Author
Message
David Bird
David Bird
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2146 Visits: 1310
Comments posted to this topic are about the item SQL Overview SSIS Package III - Full Package

David Bird
DoubleD
DoubleD
Old Hand
Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)

Group: General Forum Members
Points: 338 Visits: 185
I cannot see the code. Where should the attachment be?
Great article otherwise! Parts 1 and 2 were great too.
Thanks!
David Bird
David Bird
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2146 Visits: 1310
The attachment to this reply has been removed

David Bird
Steve Jones
Steve Jones
SSC Guru
SSC Guru (300K reputation)SSC Guru (300K reputation)SSC Guru (300K reputation)SSC Guru (300K reputation)SSC Guru (300K reputation)SSC Guru (300K reputation)SSC Guru (300K reputation)SSC Guru (300K reputation)

Group: Administrators
Points: 300314 Visits: 20005
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
My Blog: www.voiceofthedba.com
Rodney Landrum
Rodney Landrum
SSC Eights!
SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)

Group: General Forum Members
Points: 904 Visits: 741
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)
sunjiulu
sunjiulu
Mr or Mrs. 500
Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)Mr or Mrs. 500 (594 reputation)

Group: General Forum Members
Points: 594 Visits: 35
well done! a new way doing autodba job using SSIS.

thanks for sharing.

jiulu



Darwin101
Darwin101
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 598
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. w00t
Rodney Landrum
Rodney Landrum
SSC Eights!
SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)SSC Eights! (904 reputation)

Group: General Forum Members
Points: 904 Visits: 741
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)
Darwin101
Darwin101
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 598
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.
Smile
David Bird
David Bird
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2146 Visits: 1310
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
Attachments
SQL_Overview_Part3.zip (239 views, 89.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search