(Using BIDS 2008 R2)
Is there any way to add parameters to a ADO or OLEDB Source without using Expressions? Just like Execute SQL Task (Control flow) and OLE DB Command (Data flow)
I find it very cumbersome to have to go and change the expression. If I add a column, then I also need to go back to the Source query, add and remove a space before it adds the column to the output. Also sometimes I forget that
I have an expression and when I save the package the Expression overrides the query I had just updated in the source.
Hope someone can help.
View Complete Post