Thursday, July 2, 2009

SQL 2005 Integration Services Video Tutorial: Part7-A Better Way to Do Input Parameters and Parameter Mapping

Part7-A Better Way to Do Input Parameters and Parameter Mapping - view details
This seventh video in the section will demonstrate to you some very common and confusing mistakes when doing input parameters and parameter mappings, which can be a substantially frustrating process in SSIS.

Highlights from this video:
  • Looking in Profiler
  • Direct Input SQL Source type
  • Parameter mapping directions
    • Input
    • Output
    • ReturnValue
  • Proper Syntax for entering SQL queries and parameter names
and much more


To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: variables, variable, script task, dts.varia bles, input parameters, parameter mapping,

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.