Viewing 15 posts - 151 through 165 (of 9,701 total)
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
Okay, so it does work with the port number. Now how do I get it to connect without the port number?
October 28, 2021 at 3:25 pm
Having lots of fun at the office. All the old guard has retired and we have several new people coming in who don't know the environment and business rules yet....
October 28, 2021 at 2:41 pm
It took me a while to realize the person in question was conflating KMS with TDE. Because I pushed back on using TDE on our specific SQL 2012 environment, they...
October 22, 2021 at 5:07 pm
Could urgently use some help here, please. https://www.sqlservercentral.com/forums/topic/encrypting-sql-2012
October 22, 2021 at 8:39 am
Thanks!
This helped me 13 years after you posted it!
So glad it did.
October 5, 2021 at 7:47 pm
Viewing 15 posts - 151 through 165 (of 9,701 total)