4 Replies Latest reply: Sep 14, 2015 12:38 PM by Karen Mujeyi RSS

    Storing a script into a CSV file-STORE error

    Karen Mujeyi

      I currently run a script in QV (snippet here) an it runs properly.  Once I try to add a STORE step, I get an error.  Can someone help me figure out what the correct syntax is supposed to be?

       

      ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near 'STORE'.

       

      Here is the script:

      SNF_ALOS:
      SELECT DISTINCT

                            Select1,
                            Select2,
                            Select3,

      FROM                  Table

      WHERE                Condition

      STORE SNF_ALOS into V:\Senior Products - Finance\SER Analysts\Clinical Analyst\Monthly Leadership Reports\SNF_ALOS\monthly_SNF_ALOS.csv(txt);
      DROP Table SNF_ALOS;

      Thank you!