How to use SSIS Variable in SQL Command
Step 1: Create 2 Variables (String), @User::Column, @User::SQL
Step 2: Configure a column name to @User::Column as (ColumnName)
Step 3: In OLEDB source set the data access mode to "SQL command from Variable",
Step 4: Configure @User::SQL as
"SELECT "+@[User::Column]+" AS Name From TableName"
Step 1: Create 2 Variables (String), @User::Column, @User::SQL
Step 2: Configure a column name to @User::Column as (ColumnName)
Step 3: In OLEDB source set the data access mode to "SQL command from Variable",
Step 4: Configure @User::SQL as
"SELECT "+@[User::Column]+" AS Name From TableName"
No comments:
Post a Comment