topic Re: Issue with loading data from SSMS in Connectivity & Data Prep

Issue with loading data from SSMS

Mur — Fri, 26 Apr 2024 16:51:41 GMT

Hello,

I have an application built in Qlik Sense which is already connected to SSMS. There are already tables pulled over from SSMS, and many reports are built using that data. I am adding a new section in the data load editor, and I am trying to pull another table from SSMS and load it into Qlik Sense. However, every time I write my load script, it gives me an error. Interestingly, when I tried loading the same data into an empty application, it worked fine. What could be the problem preventing me from pulling the data into my existing application?

My load script is simple:

Load:

select ID, Rev1, Rev2,Rev3

From ABCTable

Where Year=2024 and Status= 'Active'

Thank you!

Re: Issue with loading data from SSMS

Fabiano_Martino_Intelco — Fri, 03 May 2024 15:07:54 GMT

Hi @Mur

can you post more information about the error?

Do you receive a specific error message?

Regards

Re: Issue with loading data from SSMS

Mario_De_Felipe — Mon, 06 May 2024 06:14:41 GMT

Probably you have a syntax error. Did you miss the final semicolon?

Load:

select ID, Rev1, Rev2,Rev3

From ABCTable

Where Year=2024 and Status= 'Active' ;

Re: Issue with loading data from SSMS

Pablo007 — Mon, 06 May 2024 07:28:26 GMT

Hi @Mur ,

Looks like you are missing single quotes in 2024

where reads =2024

Should read ='2024'

Re: Issue with loading data from SSMS

mshann01 — Mon, 06 May 2024 13:33:24 GMT

You definitely don't need quotes around the year value. Even if it was improperly stored as a varchar, SQL Server converts it on the fly and never throws an error for that.

Re: Issue with loading data from SSMS

mshann01 — Mon, 06 May 2024 13:34:10 GMT

send us error and the full script and we'll tell you what the issue is

Re: Issue with loading data from SSMS

Mur — Mon, 06 May 2024 13:35:13 GMT

Thank you all... I found the error.