Viewing 15 posts - 121 through 135 (of 9,675 total)
The most annoying thing I find about the time sheet thing is at my workplace they don't have many projects. Just "maintenance," "admin" (for PTO / meetings / training,...
December 22, 2021 at 11:27 am
We've got a new-ish director (been here almost a year), a new DBA manager, and two new DBAs which means a major work culture shift for our team. Especially as...
December 21, 2021 at 10:02 am
I don't know what API he's using, but I will forward the information. Thanks!
November 9, 2021 at 2:32 pm
I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?
One of our Devs has a question. He's trying to get Power...
November 9, 2021 at 2:15 pm
My browser is getting the time zone off my desktop, which is definitely Eastern time. My VPN would be in Central time if that was it. So I'm not sure...
November 9, 2021 at 9:58 am
Okay. FINALLY. Apparently just editing the command line from the Integration Services job step type wasn't going to do it.
I needed to revert to the old version of the job,...
November 8, 2021 at 8:16 pm
I agree with you on the security issues, but "the law" has been handed down for reasons I can't go into on a public forum. My hands are tied.
Are you...
November 8, 2021 at 5:50 pm
Command line is:
dtexec.exe /DTS "\"G:\SSIS\Folder\MyPackage\"" /SERVER MyInstance /CONFIGFILE "\"E:\Folder\Configfiles\MyPackage.dtsConfig\"" /CHECKPOINTING OFF /REPORTING E
change to:
dtexec.exe /FILE "\"G:\SSIS\Folder\MyPackage.dtsx\"" /CONFIGFILE "\"E:\Folder\Configfiles\MyPackage.dtsConfig\"" /CHECKPOINTING OFF /REPORTING E
Nope. New error.
Description: Unable to load the package...
November 8, 2021 at 1:08 pm
Just verified the DCOM permissions add doesn't allow me to connect to SSIS via SSMS with my non-administrator account.
November 8, 2021 at 1:00 pm
No go with /FILE.
Executed as user: <ServiceAccount>. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4102.2 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. The File option cannot be...
November 8, 2021 at 11:48 am
I'm using drive letters because we're using a folder on the local-to-the-server SAN, not a NAS. The last time we tried using a NAS share, things kept breaking every time...
November 8, 2021 at 11:46 am
We're using both DNS aliases and SQL aliases. We have too much code connection strings using just the instance names, so I was trying to make this migration easy by...
October 29, 2021 at 3:34 pm
Well, some instances may not use port 1433 !
You'll actually need to double check that the instance you are trying to address is actually the one listening at that...
October 29, 2021 at 1:29 pm
> Okay, so it does work with the port number. Now how do I get it to connect without the port number?
Start the SQL Browser service.
It was already started....
October 28, 2021 at 5:21 pm
Nevermind. Apparently 50 restarts of the service and recreating the aliases a dozen times will finally get it to work. And must use port 1433 to get the alias to...
October 28, 2021 at 3:28 pm
Viewing 15 posts - 121 through 135 (of 9,675 total)