November 28, 2011 at 2:27 pm
I need to learn how to create custom ssis dataflow tasks. I've been told that my new company often will incorporate stored procedures inside a custom task. Is there a book someone can recommend that I can use to learn how to do this?
November 28, 2011 at 3:18 pm
dndaughtery (11/28/2011)
I need to learn how to create custom ssis dataflow tasks. I've been told that my new company often will incorporate stored procedures inside a custom task. Is there a book someone can recommend that I can use to learn how to do this?
Narm?
A stored procedure is usually used in the control flow as an execute SQL object or as a data source for a lookup or data source component.
What exactly are they doing with these stored procedures that they're creating custom SSIS objects? They're not created lightly.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 28, 2011 at 3:48 pm
I'm not sure what they are doing yet. I just need to learn how to do this.
November 29, 2011 at 11:51 am
I believe Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer) talks about it in a later chapter, that is where I got enough information to build my first one. And they are fairly involved so I wouldn't take building one lightly.
CEWII
November 30, 2011 at 7:30 am
Why not walk the code of one they have created? If they have standards and conventions, it will be best to get learned on their procedures.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply