• Hi all,

    thanks Phil and Mack for your quick answer.

    In my scenario both options (stored procedure and script taks) work fine.

    I need to update an operational CRM (Dynamics - SQL DB) using data from an analytical CRM (SAS+SQL DB). Both databases are in the same server, so I just need to parameterized the target or the source. It is just to make the deployment more flexible but is not a strong requirement. As I said, both solutions will work.

    Kind Regards,

    Paul Hernández