kwoznica (3/30/2011)

You mention C# as a scripting tool in conjunction with SSIS. How important is it to know C# for SSIS and what shortcomings do you face without it?

Is...

Just poking my head into the conversation to say the following:

I was a hiring manager for a couple years and hired many SSIS developers. As others have stated in this...

Hi Dave,

Bret Flippen wrote a good article on this here[/url]. I implemented his suggestions recently at a client and, during an exchange on Twitter, Brett directed me...

Hi Radh,

In some versions/service packs of SSIS - mostly 2005 - I've encountered a similar issue. If I muck with the Package ProtectionLevel property, I can end...

Hi Green,

You're welcome. SSIS is difficult, but not impossible, to learn. I learned it - that means anyone can! I've also trained hundreds of SSIS developers over...

Hi Green,

It's ok to have questions. SSIS is a complex topic and you're on one of the steeper slopes of the learning curve.

I think...

Hi String,

This is most likely going to involve scripting. Powershell is probably your first best choice but I don't know enough Powershell to help you. You can...

Hi Green,

PreExecute fires when the Script Component is initialized in the Data Flow Task. It's there to allow you do anything you need prior to the script...

Hi Robin,

If you set the MaximumErrorCount property on the Container to 3, that should do it. It defaults to 1 and so fails on the first error....

I maintain the best tools were once toys.

:{>

Hi Gmby,

I don't override configurations at the command line, but what about pluralizing the package collection name: \Package.Configurations?

Andy

Hi Carlo,

You are correctly confused, as was I. In most applications the command line wins. I researched this change some and there is at least one legitimate...

Hi Craig,

Yes.*

:{> Andy

*There's more to it than that. It includes a discussion of when to use which configuration options and how to combine them so you can...

Another great question Steve!

I have to agree with those who've already responded with "It depends." That's not a cop-out, it's a valid question and each business needs...

Great editorial Steve!

I agree with Hugo's response. In the physics software teams, an over-emphasis on process is the path of least resistance. If an entry-level person can...