How to execute "Raw SQL" in a script task process ...

Hi community!



I finally found the solution!!! : using the Class CustomQuery like this:

var userConnection = Get<UserConnection>("UserConnection");

string sql =" ......."; 

CustomQuery myQuery = new CustomQuery(userConnection);

myQuery .SqlText = sql;

using (DBExecutor dbExecutor = userConnection.EnsureDBConnection())

{

    dbExecutor.CommandTimeout = 0;

    myQuery .Execute();

}

return true;