Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS - dynamic connection - verify data source using script task and email if connection RE: SSIS - dynamic connection - verify data source using script task and email if connection

  • August 28, 2012 at 9:21 am

    #1530886

    Not sure why you have the variable 'Server' set up with a Datatype of Object.

    Second

    Not sure if just saying 'aquireconn' in the foreach will mean you arfe testign connectivity.

    Email sending : use the sendmail task.