Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Experiences from a Real World Project


Experiences from a Real World Project

Author
Message
Jamie Thomson
Jamie Thomson
SSC Eights!
SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)

Group: General Forum Members
Points: 885 Visits: 188
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jthomson/3219.asp

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Dave Diehl-263874
Dave Diehl-263874
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 2
Good article. As someone who's worked with SSIS for about a year, a lot of your recommendations rang true.

I'm not sure I concur with the one-configuration-setting-per-configuration-file suggestion however. If you have more than 10 settings...that could make for more headaches that it's worth. Add different configuration locations (database, XML, registry, etc) and that would just compound the problem. Bundling them into groups, by their functionality, would be a better approach IMO.

What's missing in the SSIS-discussion-space is a good article on utilizing the event handlers. To be honest, I've ignored them but would like to see how they could effectively be used.
VincentRainardi
VincentRainardi
SSC Journeyman
SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)SSC Journeyman (83 reputation)

Group: General Forum Members
Points: 83 Visits: 191

Thank you for sharing your real project experiences with us Jamie.
They are especially valuable as you are one of the most expert person in SSIS.
Vincent


Sarah Grove
Sarah Grove
Old Hand
Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)Old Hand (340 reputation)

Group: General Forum Members
Points: 340 Visits: 317

Good article. I use most of your suggestions already. However, I use the SSIS log provider for Text files and just let each package execution append to the end of the log. I have the package begin and end logged as a way of determining where each execution began. I use Excel to read the log files; since the last execution of the package is at the end of the file, once the log is open I just scroll down to the bottom. It takes a couple of extra seconds, but with all the history there in one place I can easily look for trends.


Jamie Thomson
Jamie Thomson
SSC Eights!
SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)SSC Eights! (885 reputation)

Group: General Forum Members
Points: 885 Visits: 188

Thanks all for the comments thus far. Certainly nothing there that I can (or would) disagree with.


Dave, I have an article here that discusses one possible use of event handlers: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx in case you're interested.

-Jamie



Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Isaac-521185
Isaac-521185
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 22
Great article. Thanks for sharing the remedies to all your pain.

For storing expressions in variables, what about expressions that should evaluate to boolean. For example '@Var1 == @Var2' . I can store that expression in a variable of type String but the Expression Builder can't convert the string into value of type boolean. Any thoughts?

Thanks in advance.
Ashesh
Ashesh
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1423 Visits: 197
Very much useful article. Thanks


Thanks,
Ashesh

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