Forum Replies Created

Viewing 15 posts - 226 through 240 (of 9,725 total)

  • Reply To: SSIS not calling powershell script

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 16, 2021 at 3:48 pm

    #3910709

  • Reply To: SSIS not calling powershell script

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 16, 2021 at 3:33 pm

    #3910707

  • Reply To: SSIS not calling powershell script

    Jeffrey Williams wrote:

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 14, 2021 at 9:08 pm

    #3908010

  • Reply To: SSIS not calling powershell script

    Jeffrey Williams wrote:

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 14, 2021 at 8:49 pm

    #3907994

  • Reply To: SSIS not calling powershell script

    Martin Schoombee wrote:

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 14, 2021 at 6:07 pm

    #3907959

  • Reply To: SSIS not calling powershell script

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 14, 2021 at 5:51 pm

    #3907946

  • Reply To: SSIS not calling powershell script

    Martin Schoombee wrote:

    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. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 14, 2021 at 2:56 pm

    #3907868

  • Reply To: SSIS not calling powershell script

    Brandie Tarvin wrote:

    ZZartin wrote:

    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. ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 14, 2021 at 1:49 pm

    #3907837

  • Reply To: SSIS not calling powershell script

    ZZartin wrote:

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 6, 2021 at 5:50 pm

    #3904053

  • Reply To: SSIS not calling powershell script

    Phil Parkin wrote:

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 6, 2021 at 5:47 pm

    #3904048

  • Reply To: SSIS not calling powershell script

    Martin Schoombee wrote:

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 6, 2021 at 5:44 pm

    #3904045

  • Reply To: Are the posted questions getting worse?

    YES!

    "Nice to have: 2k years experience with DBCC TIMEWARP()."

    And then sit back and see how many people actually respond. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 1, 2021 at 8:35 pm

    #3902640

  • Reply To: Are the posted questions getting worse?

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 1, 2021 at 8:01 pm

    #3902621

  • Reply To: Powershell SFTP script not correctly pulling file

    frederico_fonseca wrote:

    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....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 25, 2021 at 12:34 pm

    #3900408

  • Reply To: Are the posted questions getting worse?

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    June 14, 2021 at 3:19 pm

    #3895998

Viewing 15 posts - 226 through 240 (of 9,725 total)