9 Replies Latest reply: Feb 23, 2015 9:39 PM by Antonio Caria RSS

    ODBC Load being ignored

      I am making several connections to retrieve data...some are OLEDB connections to SQL data source, one is to SalesForce.com, some are .xls files.   These are working fine.

       

      Now I'm trying to connect to an Access DB vie an ODBC connection.  I have the connection statement, with a Load statement followed by a SQL statement followed by a Drop Fields statement.  However when I run the script it doesn't load...it just gets ignored.  It seems like whether I place it in a separate tab or in the same tab as other statements it either gets ignored or gives an error that the connection can't be made.

       

      What could be going on?  What should I try to do?  When I run it by itself it is successful.

       

      Thanks!   Dan