on each server, can you check this Server Setting?

Perform Volume Main task for fast database creation.

if you changed the service account after the initial install, i might expect to see...

here's a snippet i use:

this will return all failures since the given date(first of the year is my parameter)

you can tweak it from there, i think.

DECLARE @dt...

the SQL Import Wizard will let you select all 260 tables in one go, and save the package for future editing, execution and modification.

one package, 260 data flows.

does the application NEVER write to the database and needs to be fixed, or does the applicaiton writing to the database works for a while, and the stops writing?

there are...

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

yes the code has problems, since . the code you pasted is incomplete.

for what you pasted, besides having a lot of whitespace so the...

if you are sure they are using the same sources, then how about a quick and dirty row count and totals by columns?

add some additional group bys to look at...

i might consider checking the  ansi and date_format sessions settings for default dates, as they could be different on the server, running as an agent , vs running in SSMS

ie...

without using .NET, then no, the specific file extension *.msg ends up requiring C# to do something like this, since the msg is a binary file:

you could save as text...

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 5 years, 3 months ago by  Lowell.
• This reply was modified 5 years, 3 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 5 years, 3 months ago by  Lowell.