I am getting the error
Error: 18456, Severity: 14, State: 16.
Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
in the log repeated every 15 seconds or so. I am logged into the server as pri\sqlservice, I have started the sql server and sql server agent with pri\sqlservice and I...
I am trying to override the default Base Unit for the X axis from days to months, but it never saves my option. Has anyone else run into this? I've searched the forums with no luck. I even tried to search Business Object's bug list, but you have to have support to do that.
I have one table with a list of finished dates (one date for each month a date range). I have another table with a line item having a finished date. I am trying to do an outer join (so I get each month) using datepart, but the results are an inner join. I've tried splitting the date out into...
I want to do a simple package that will send an e-mail if the rowcount of a query is > 0.
I add the rowcount data flow component and assign a variable cnt.
In the precendence constraint I add the expression @cnt > 0.
When I run, I get the error The expression "@cnt > 0" must evaluate to True...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.