119 how can we load that special char rows into error table

[@prajaakeeyaparty6578]

HI Aqil...can't we use derived column transformation to remove special characters

[@learnssis]

Yes we can use derived column transformation as well to remove special characters but the method that I am aware is that we can use Replace function where we explicitly need to provide the special character in the Replace function. Replace(columnname,"@","") Above code will replace the @ from columnname in derived column transformation.

[@deepakj6717]

In Execute SQL Task how to call stored procedure with parameters? How to return any value from stored procedure. What is the use of 'Direction' column in Parameter Mapping section.

[@learnssis]

We can call the stored procedure normally as we can call it using sql query. We can write the query in the sql statement source in expression and pass the parameters using SSIS variables. Similar to sql we can assign the result to sql output parameter to a local sql variable and then we can select and assign that value to an ssis variable. The use of 'Direction' column in Parameter mapping is to denote if the parameter is an input parameter or output parameter. I will try to make a video on calling stored procedure with input and output parameters in SSIS execute sql task.

[@reddyabhik]

Very well explained, on how to separate the rows if any column has sp@ci*l characters

[@learnssis]

Thank you Abhilash.