5 Replies Latest reply: Dec 16, 2012 7:28 AM by Sunil Chauhan RSS

    Script Error

    Marina Alvarez Ruiz

      Help

       

      That's my script and my error window

       

      error.jpg

       

      Let ThisExecTime = ReloadTime();

       

       

      QV_Table:

      LOAD BusinessEntityID,

          ModifiedDate,

          PasswordHash,

          PasswordSalt,

          rowguid;

      SQL SELECT BusinessEntityID,

          ModifiedDate,

          PasswordHash,

          PasswordSalt,

          rowguid

      FROM AdventureWorks2008.Person.Password

      WHERE ModifiedDate >= #$(LastExecTime)#;

       

      Concatenate LOAD BusinessEntityID,

          ModifiedDate,

          PasswordHash,

          PasswordSalt,

          rowguid FROM File.qvd (qvd);

       

       

                STORE QV_Table INTO QV_Table.qvd (qvd);

                Let LastExecTime = ThisExecTime;

        • Re: Script Error

          Have you tested the connection to the Database? And if so, try to find the table "AdventureWorks2008.Person.Password" through the select button under the Data tab.

            • Re: Script Error
              Marina Alvarez Ruiz

              OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks2008;Data Source=COMGAD;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=COMGAD;Use Encryption for Data=False;Tag with column collation when possible=False];

               

               

              Let ThisExecTime = Date(ReloadTime());

               

               

              QV_Table:

              LOAD BusinessEntityID,

                  ModifiedDate,

                  PasswordHash,

                  PasswordSalt,

                  rowguid;

              SQL SELECT BusinessEntityID,

                  ModifiedDate,

                  PasswordHash,

                  PasswordSalt,

                  rowguid

              FROM AdventureWorks2008.Person.Password

              WHERE ModifiedDate >= #$(LastExecTime)#;

              //       AND ModifiedDate < #$(ThisExecTime)#;

               

               

              Concatenate LOAD BusinessEntityID,

                  ModifiedDate,

                  PasswordHash,

                  PasswordSalt,

                  rowguid FROM QV_Table.qvd (qvd);

              //WHERE NOT EXISTS(PrimaryKey);

              //

              //Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

               

               

              If ScriptErrorCount = 0 then

                        STORE QV_Table INTO QV_Table.qvd (qvd);

                        Let LastExecTime = ThisExecTime;

              End If