how to use system variables in OLE DB Command transformation?
it seems that i can only map input columns to parameters in SQL Command(SqlCommand in the Common Properties Tab),
while i hope i could directly map global variables to parameters.
and the SqlCommand can not be anything like "insert into tableA(col1,col2) values(?,@[System::StartTime])"
yes, i can add variables to pipeline by using Derived Column transformation. but it of course is not convenient.
thanks in advance.Andrew Chen
Interested in BI related technologies
View Complete Post