qadding the columns them selves is just a DDL operation. you would not need to do that inside SSIS.

ALTER TABLE ADD Column1 varchar(etc...

i suspect you mean what about the data...

BIDS is the older version for SSIS development from SQL2005 to SQL2008R2

in 2012 and Above, BIDS had a name change to SSDT(SQL Server Data Tools). it is basically the same...

i think this will fix just two items though; won't he have continued issues when he discovers %20 or other url encoded values?

i would think  we need to consider all...

• This reply was modified 6 years, 2 months ago by Lowell.
• This reply was modified 6 years, 2 months ago by Lowell.

that reminds me of one of those bad practice examples i wrote, to show how confusing keywords as object names could be.

IF NOT EXISTS(SELECT 1 FROM sys.databases...

can you try EXECUTE AS LOGIN='domain\user' instead of execute as user, and execute from , say the master database as the context?

can you duplicate the user error then?

it sounds like you might have removed public permissions from the server,and specifically in master? could that have happened?

if the end user is using something like SSMS, they typically get...

i wrote/modified/collected some powershell scripts to disable various group policies or services that are related to CEIP and other unnecessary services.

I hope this helps.

###################################################################################################
##disable cortana 
###################################################################################################
New-Item -Path...

• This reply was modified 6 years, 2 months ago by Lowell.

Unfortunately, unless you have set something up previously, this is not possible. No default setting captures that level of information, as the log would probably exceed the database size.

also, no-one...

dtexec /Server "SERVER-INSTANCE" /envreference "DEV" /isserver "\SSISDB\Sample\Sample\pkg_Sample.dtsx" /par "$ServerOption::SYNCHRONIZED(Boolean)"

the red part i highlighted is the definition, and not the value, isn't it?

i think it is supposed to actually also...

your issue is ISNULL and implicit conversions.

ISNULL(NumericColumn,'') fails because numeric column can never be empty string  (the value of '')

the isnull function is attempting to cast the varchar value of...

• This reply was modified 6 years, 3 months ago by Lowell.

are you sure you are sysadmin on the server? the error implies either the spelling of the trigger is incorrect, or you do not have permissions.

if you have view any...

• This reply was modified 6 years, 3 months ago by Lowell.

on the SQL server itself, someone has created a logon trigger on all server.

that trigger is preventing the login...it might be doing it on purpose, or it might be an...

• This reply was modified 6 years, 3 months ago by Lowell.
• This reply was modified 6 years, 3 months ago by Lowell.

looks like although it has a lot of moving parts to set it up, there's a decent article from Ms to help with the walk through:

this link is for SQL2017,...

i think you are targeting the wrong tool.

you want to use an SSIS package to pull data from SQL, and let that do the HTTP post.

SQL, by itself, does not...

so the scale out deployment will distribute the reports executions out to the SSRS farm, which is great if you have lots of calls to the reports. I would expect...