Viewing 15 posts - 211 through 225 (of 9,712 total)
Fortunately, my employer has decided a majority of people can be Work From Home, with only some doing part WFH and part in-Office, and a rare, essential few doing in-Office...
July 22, 2021 at 12:53 pm
Is the SSIS task waiting for completion before returning success? I may have been wrong in my original assessment of the disconnected execution, which has been my experience in...
July 17, 2021 at 1:30 am
YESYESYESYESYES... Second Execute Process task working as well!!!!
I had the wrong freakin' switch!
I hate it when I spend so much time trying to troubleshoot something and it turns out to...
July 16, 2021 at 3:48 pm
HA! SUCCESS!
So, I knew it wasn't running because the powershell script loads the file header information into a database table. And nothing was happening when I ran this in SSIS...
July 16, 2021 at 3:33 pm
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
Viewing 15 posts - 211 through 225 (of 9,712 total)