Viewing 15 posts - 166 through 180 (of 9,665 total)
It seems there is something blocking the execution of the script - have you tried copying the script to a local drive and just executing the script directly from...
July 14, 2021 at 9:08 pm
I wonder if using ExecutionPolicy Unrestricted in the command line is overriding the previous Bypass setting on the command line? You don't actually need to specify both - one...
July 14, 2021 at 8:49 pm
Yeah...I would try unrestricted for the local machine (not user) too, if that's an option.
I dearly wish I could, just to test, but Corporate had a whole to-do about...
July 14, 2021 at 6:07 pm
Running VS as Administrator didn't work. I tried copying the package to my desktop and running it in 2019 and that didn't work.
I'm going to ask a coworker who has...
July 14, 2021 at 5:51 pm
Hmmm...your PS script might not even be initiated at all.
What is your local PS execution policy, and is the account you're using a local administrator?
Yes, I am local admin. ...
July 14, 2021 at 2:56 pm
First step just add some simple file logging to the powershell script, just a hello at the start and good by eat the end to a temp file. ...
July 14, 2021 at 1:49 pm
First step just add some simple file logging to the powershell script, just a hello at the start and good by eat the end to a temp file. That...
July 6, 2021 at 5:50 pm
Are there any clues in the All Executions report (All Messages)?
What is different about this package? Software versions? Different instance?
I looked at output and didn't see any messages in...
July 6, 2021 at 5:47 pm
Your subsequent tasks execute, but fail because the PowerShell script has not finished running yet.
I don't disagree with this comment, but... There is a precedence constraint between this task...
July 6, 2021 at 5:44 pm
YES!
"Nice to have: 2k years experience with DBCC TIMEWARP()."
And then sit back and see how many people actually respond. @=)
July 1, 2021 at 8:35 pm
I find myself wanting to put in our DBCC Time() joke in the next wanted ad I help design (must have 2000 years experience!) but now I can't remember the...
July 1, 2021 at 8:01 pm
make sure the powershell version is setting the "Binary" mode for transfer - if not and if the default is not binary it will mess it up.
Oh, good grief....
June 25, 2021 at 12:34 pm
So fun thing I just realized, glancing at it again. The trigger is doing error handling. Yes, it's doing an audit thing for updating a history table, but … it's...
June 14, 2021 at 3:19 pm
I just took a glance at the trigger. The size of the thing is truly horrendous.
Not sure if it was truly built for single row processing because it'll probably take...
June 14, 2021 at 2:02 pm
Brief tangent into real SQL stuff...
Has anyone ever heard of table triggers not firing for every row if you do set-based updates to records?
Our vendor sent us code for an...
June 14, 2021 at 1:01 pm
Viewing 15 posts - 166 through 180 (of 9,665 total)