SSIS Tips & Tricks (Presentation)

Posted on SQLIS See other posts from SQLIS
Published on Thu, 21 May 2009 09:01:46 +0400 Indexed on 2010/04/12 15:34 UTC
Read the original article Hit count: 294

Filed under:

Presentations

|

User Group

This has been a rather well used presentation title but it does allow a certain degree of flexibility, and we covered a good range of topics in my session at the UK SQL Server User Group in Cambridge last night. Thanks to all who attended.

Here is the rather limited slide deck and the all important demo packages for download as promised.

For reference, high level topics covered were

BIDS Helper
Inserts and Updates
Transactions
Script Debugging
Data Flow Checkpoints

I’ll update the post with a link to the Live Meeting recording when I get it.

Presentation & Demo Packages (194KB) SSIS Tips & Tricks - Darren Green.zip

© SQLIS or respective owner

Related posts about Presentations

How to create animated presentations/video-presentations?

as seen on Super User - Search for 'Super User'
Making presentation using PowerPoint is kind of too simple, it's possible to make nice presentations but I would like do a step forward. I'm wondering how people make animations like this one: http://www.facebook.com/video/video.php?v=10150210521510484 ? >>> More
Change Data Capture Webinar

as seen on SQLIS - Search for 'SQLIS'
I am going to be doing a webinar with our friends at Attunity on Change Data Capture. Attunity have a good story around this technology and you can use it in your SSIS loads to great effect. Join Attunity and Konesans/SQLIS for a Webinar on 17 September Space is limited. Reserve your… >>> More
Change Data Capture Webinar

as seen on SQLIS - Search for 'SQLIS'
I am going to be doing a webinar with our friends at Attunity on Change Data Capture. Attunity have a good story around this technology and you can use it in your SSIS loads to great effect. Join Attunity and Konesans/SQLIS for a Webinar on 17 September Space is limited. Reserve your… >>> More
Manchester UG Presentation Video

as seen on SQLIS - Search for 'SQLIS'
In July I was invited to speak at the UK SQL Server UG event in Manchester. I spoke about Excel being a good data mining client. I was a little rushed at the end as Chris Testa-ONeill told me I had only 5 minutes to go when I had only been talking for 10 minutes. Apparently I have… >>> More
Learn Lean Software Development and Kanban Systems

as seen on Johnny Coder - Search for 'Johnny Coder'
I did an in-house presentation on Lean Software Development (LSD) and Kanban Systems this week. Beyond what I had previously learned from various podcasts, I knew little about either topic prior to compiling my slide deck. In the process of building my presentation, I learned a ton. I found the… >>> More

Related posts about User Group

blocking bad bots with robots.txt in 2012 [closed]

as seen on Pro Webmasters - Search for 'Pro Webmasters'
does it still work good? I have this: # Generated using http://solidshellsecurity.com services # Begin block Bad-Robots from robots.txt User-agent: asterias Disallow:/ User-agent: BackDoorBot/1.0 Disallow:/ User-agent: Black Hole Disallow:/ User-agent: BlowFish/1.0 Disallow:/ User-agent: BotALot Disallow:/ User-agent:… >>> More
polkit: disable all users except those in group wheel?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Is it possible to do the following using 1 polkit .pkla file? Disable all users except those in the wheel group from using polkit. The users in the wheel group will need to provide the root password when using polkit. /etc/polkit-1/localauthority/50-local.d/wheel-only.pkla [disable all users… >>> More
Redirect network logs from syslog to another file

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I keep logging way to much info (not needed, for now) in my syslog, and not daily or hourly... but instant. If I want to watch for something in my syslog I just can't because the network log keeps interfering. So, how can I redirect network logs to another file and/or stop logging it? Dec 10 17:01:33… >>> More
More efficent way to do this?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a if function that works out how much of a users profile is completed however the way I include below was the best I could think of, however it seems really inefficient. What is the better way to do this? if($user['first_name']!==""&&$user['last_name']!==""&&$user['pemail']… >>> More
PHP If/Else - More efficent way to do this?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a if function that works out how much of a users profile is completed however the way I include below was the best I could think of, however it seems really inefficient. What is the better way to do this? if($user['first_name']!==""&&$user['last_name']!==""&&$user['pemail']… >>> More