2 Replies Latest reply on Mar 15, 2013 11:43 AM by Michael Holloway

    SQL Server data connection is missing column while trying to import

    Michael Holloway

      Greetings, When trying to import a table from SQL Server, all columns are imported successfully minus a single time column.  I’ve tried to query for the column alone and the results come back blank. I’ve also tried to write the query as SELECT * FROM … and same result.  25 columns are pulled in minus one column titled [RPT_TS].

       

      I verified the column imports in Excel without issue via a SQL connection.

       

      I’ve looked in the database and I can’t find another table with this same name.

       

      I’m fairly new to the product so I may have inadvertently done something to cause this issue.

       

      Thanks for any assistance in advance.

       

      Michael