Suggestion: Output the .Net that would be required to build the package programatically

Oct 14, 2009 at 9:44 AM

As discussed in this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c25577ca-c99d-44bc-91cf-727a1ce0e8d3

it might be handy to have a utility that could produce some .Net code that would build the specified report

 

-Jamie

Oct 14, 2009 at 3:04 PM

This would be a KILLER feature. I've suggested this to the SSIS team on several occasions, but having it in BIDS helper would definitely do the trick for me.

Coordinator
Oct 14, 2009 at 4:37 PM

Great suggestion, guys.

This suggestion applies equally well to SSAS and SSRS. So my question is which of those should be prioritized? SSIS, SSAS, or SSRS?

Oct 14, 2009 at 5:01 PM

Hi Greg,

Well I'm kinda biased but in all honesty I do think SSIS would be best. I think there's more call for building SSIS packages programatically than cubes or reports.

 

-Jamie

 

Oct 14, 2009 at 8:07 PM
jamiet wrote:

Hi Greg,

Well I'm kinda biased but in all honesty I do think SSIS would be best. I think there's more call for building SSIS packages programatically than cubes or reports.

 

-Jamie

 

Completely agreed, both on the answer and on the rationale and bias.

 

Coordinator
Oct 14, 2009 at 10:41 PM

I think if we asked Matthew and Jamie any question the answer would always be SSIS  :)

But I do agree, I think that it probably would be the most useful of the 3, unfortunately it is probably the hardest given the nature of it's API. I'm not sure if that ezAPI project is worth looking into.

Coordinator
Oct 15, 2009 at 2:56 AM

There's a product that does this here: http://www.ivolva.com/ssis_code_generator.html However, it only generates the control flow side, as of the last time I looked at it. Granted, that was about 2 years ago.

I'm not sure how useful EzAPI would be for this. It works pretty well for generating packages, but it has some limits. To reverse engineer packages, you'd probably need a little more flexibility than it offers. However, it would be an interesting feature.

Oct 15, 2009 at 4:37 AM
johnwelch wrote:

There's a product that does this here: http://www.ivolva.com/ssis_code_generator.html However, it only generates the control flow side, as of the last time I looked at it. Granted, that was about 2 years ago.

I'm not sure how useful EzAPI would be for this. It works pretty well for generating packages, but it has some limits. To reverse engineer packages, you'd probably need a little more flexibility than it offers. However, it would be an interesting feature.

I would argue that a tool that only does control flow is pretty much worthless. The control flow is the trivial part that can be done today with ease, without tools...

Coordinator
Oct 15, 2009 at 4:02 PM

You won't get any argument from me on that, though I don't think it's entirely worthless. After all, looking at what it produced was what got me started with the API.