=IIf(User!UserID.Value = "DOMAIN\username", Fields!SalesTotal.Value, "0")

Consider returning all...

Thom - these issues are related to datetime/smalldatetime data types.  The format YYYY-MM-DD is a valid ISO date format but is not handled correctly in SQL Server when using either...

I don't use it a lot - but I do have several scripts where it is very useful.  For example - creating logins/users in an AOAG environment.  The script creates...

You want the text qualifier to be set to double quotes.  That is set in the connection manager for the file.

Thanks. I might be missing something here but we seem to be creating a table and populating it – I don’t see how we end up with a physical file....

I created and saved an SSIS package. On the “Control Flow” screen, I would expect to see a “Run” or “Execute” button, so I can manually run the package &...

• This reply was modified 6 years, 11 months ago by Jeffrey Williams.

The ideal solution would be to publish the report to SSRS - and schedule it to export to an Excel or PDF file as needed.

Since you do not want to...

You stated you had previously granted update access to the user - once granted it will remain until explicitly revoked. So now this user has db_datareader role AND explicit...

The agent service actually runs under a special service SID account (NT SERVICE\SQLSERVERAGENT). That account has sysadmin rights to SQL Server and allows the agent jobs to run with...