Thanks

Thanks

I'm able to connect to the named instance when I'm in office, not on VPN when working remotely(home).

Browser service is running and a fixed port has been assigned to...

I would script out the user permissions ( server/databases/object/column/certificates.. level) before dropping from the server/databases just for the safe side if I need to re-enable. Also check for any job...

Thanks, does using fqdn uses only tcp/ip protocol on sqlclient connectivity not named pipes?

Thanks, it's intermittent failures. What network test can be done regarding this issue?

Still get these errors few times every day.

Should this be a firewall/network issue? Or is this a connection string issue?

Please see the error.

Error Context summary:

CreationNameMicrosoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=12.0.0.0, Culture=neutral, PublicKeyToken=34123rfg8080yy89

DebugModeFalse

DefaultActiveItemScriptMain.cs

DelayValidationFalse

DescriptionScript Task

DisableFalse

DisableEventHandlersFalse

EntryPointMain

ExecutionDuration0

ExecutionResult0

ExecutionStatus3

FailPackageOnFailureFalse

FailParentOnFailureFalse

ForcedExecutionValue0

ForceExecutionResult-1

ForceExecutionValueFalse

IsDefaultLocaleIDTrue

ProjectTemplatePathC:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\IS_ST_CS_Template.vstax

ReadOnlyVariablesSystem::TaskName,User::Task_id,System::PackageName,User::UNC_FILE_PATH

ScriptLanguageMicrosoft Visual C# 2012

ScriptLoadedTrue

SuspendRequiredFalse

TransactionOption1

Version0

Yes Phil, Using Windows authentication. Also as part of the package a report file(excel) is created on the shared folder. All other packages runs fine when executed from remote client/SSMS.

The log file is updated on the remote share which includes the number of records updated on that run.

Not sure what will be issue the service account permission. When I run from ssis catalog from the server, it's running fine.

What are the required permissions for service account/proxy on...

Thanks Robert

Tava (4/14/2016)

---

For our SSIS process we have a dedicated ETL Server per environment (TST/STG/PROD - TST way lower specs), all our packages run on here and perform all the Extract,...

thanks Tava!