Forum Replies Created

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

  • 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

  • Reply To: Are the posted questions getting worse?

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

    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 2:02 pm

    #3895962

  • Reply To: Are the posted questions getting worse?

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

    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 1:01 pm

    #3895930

  • Reply To: SSIS package succeeds but fails

    I wasn't actually the one who pushed the SSIS packages to this particular server. I'm not sure if it was just imported straight from 2012 to 2019 or if it...

    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.

    May 5, 2021 at 10:57 am

    #3879560

  • Reply To: SSIS package succeeds but fails

    Despite the above reply, if anyone has ever seen this behavior before or has any ideas (aside from telling me to change how I run the package), please let me...

    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.

    May 4, 2021 at 9:47 pm

    #3879361

  • Reply To: SSIS package succeeds but fails

    We don't have catalogs set up and we've got such a tight deadline on the server upgrade that I don't have time to set them up right now. Catalogs are...

    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.

    May 4, 2021 at 7:06 pm

    #3879301

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