Forum Replies Created

Viewing 15 posts - 166 through 180 (of 9,720 total)

  • Reply To: Are the posted questions getting worse?

    >>>>Eirikur Eiriksson wrote:

    >>>Grant Fritchey wrote:

    >>Sean Lange wrote:

    >And in other news....I have taken the plunge. After almost 25 years as a developer I have just accepted a new position as a...

    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.

    February 3, 2022 at 4:38 pm

    #3980497

  • Reply To: Are the posted questions getting worse?

    Got an email from Degreed.com giving me recommendations for virtual training and … well, apparently there are urgent SQL courses I need to take today and ...

    Well, what do you...

    Attachments:
    You must be logged in to view attached files.

    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.

    December 28, 2021 at 7:29 pm

    #3967937

  • Reply To: Are the posted questions getting worse?

    The most annoying thing I find about the time sheet thing is at my workplace they don't have many projects. Just "maintenance," "admin" (for PTO / meetings / training,...

    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.

    December 22, 2021 at 11:27 am

    #3966271

  • Reply To: Are the posted questions getting worse?

    We've got a new-ish director (been here almost a year), a new DBA manager, and two new DBAs which means a major work culture shift for our team. Especially as...

    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.

    December 21, 2021 at 10:02 am

    #3965858

  • Reply To: Are the posted questions getting worse?

    I don't know what API he's using, but I will forward the information. Thanks!

    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.

    November 9, 2021 at 2:32 pm

    #3949486

  • Reply To: Are the posted questions getting worse?

    I am not seeing a Power BI forum on this group. Is there one and I'm just missing it?

    One of our Devs has a question. He's trying to get Power...

    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.

    November 9, 2021 at 2:15 pm

    #3949476

  • Reply To: Site time stamps wrong

    My browser is getting the time zone off my desktop, which is definitely Eastern time. My VPN would be in Central time if that was it. So I'm not sure...

    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.

    November 9, 2021 at 9:58 am

    #3949388

  • Reply To: Permissions Error Running DTEXEC on SQL Agent job

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

    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.

    November 8, 2021 at 8:16 pm

    #3949200

  • Reply To: Permissions Error Running DTEXEC on SQL Agent job

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

    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.

    November 8, 2021 at 5:50 pm

    #3949159

  • Reply To: Permissions Error Running DTEXEC on SQL Agent job

    frederico_fonseca wrote:

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

    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.

    November 8, 2021 at 1:08 pm

    #3949037

  • Reply To: Permissions Error Running DTEXEC on SQL Agent job

    Just verified the DCOM permissions add doesn't allow me to connect to SSIS via SSMS with my non-administrator account.

     

    Attachments:
    You must be logged in to view attached files.

    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.

    November 8, 2021 at 1:00 pm

    #3949033

  • Reply To: Permissions Error Running DTEXEC on SQL Agent job

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

    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.

    November 8, 2021 at 11:48 am

    #3949011

  • Reply To: Permissions Error Running DTEXEC on SQL Agent job

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

    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.

    November 8, 2021 at 11:46 am

    #3949010

  • Reply To: SQL Instance Aliases - Urgent assistance needed please

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

    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.

    October 29, 2021 at 3:34 pm

    #3946012

  • Reply To: SQL Instance Aliases - Urgent assistance needed please

    Johan Bijnens wrote:

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

    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.

    October 29, 2021 at 1:29 pm

    #3945946

Viewing 15 posts - 166 through 180 (of 9,720 total)