Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
#SQLServer 46
SQL Server 44
SSRS EXPERT 41
BI 36
#BI 33
brh 28
SSIS BEST PRACTICES 23
TSQL 19
MS BI STACKS 18
SSRS 17

Archive · View All
March 2011 24
July 2011 17
February 2011 15
April 2010 13
June 2011 11
May 2011 11
April 2011 11
July 2010 11
March 2010 8
December 2011 7

SSIS – Pass a variable to a OLE DB Source in a Data Flow

Mar 6 2011 4:00AM by Sherry Li   

Continue from SSIS – Use “Foreach Loop Container” and pass a variable to a OLE DB Source in a Data Flow.

Step 2: Create a data flow step, into which we are going to pass a variable

Step 3: Create an OLE DB Source, Destination and a Data Conversion

Step 4: In the OLE DB Source Editor, write a SQL query.

Notice the WHERE clause, WHERE M.TIME_DAY_GEN_ID = cast( ? as date ).

The question mark ? indicates that we need a parameter for this query.

Attention: when writing SQL query in this editor, always start with a simple query. The editor is not very sophisticated SQL editor. Complex SQL queries will confuse the editor.

Step 5: Click the Parameters… button.

In the Set Query Parameters windows, add a parameter by setting Parameter0 under Parameters, and User::vLoopDate under Variables.

Continue to finish the Column mappings.

We are done now.

If you open the Advance Editor for the OLE DB Source, you will see this in the Component properties tab.

Notice the ParameterMapping and the SQLCommand properties.

Tags: SSIS BEST PRACTICES,


Sherry Li
14 · 12% · 3827
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]