Forum Replies Created

Viewing 15 posts - 241 through 255 (of 9,720 total)

  • Reply To: SSIS package succeeds but fails

    frederico_fonseca wrote:

    event viewer - see this link for some info https://docs.microsoft.com/en-us/sql/integration-services/performance/events-logged-by-an-integration-services-package?view=sql-server-ver15

    better to run packages on filesystem or catalog - easier to check errors and easier to change logging level

    Thank...

    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.

  • Reply To: SSIS package succeeds but fails

    The report returns nothing. It's completely empty despite our QA team having run several of the jobs that call the packages. But again, we're not using SSIS Catalog and 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.

  • Reply To: Are the posted questions getting worse?

    I am SOOOOOOO confused. Help appreciated here:  https://www.sqlservercentral.com/forums/topic/ssis-package-succeeds-but-fails

    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.

  • Reply To: Are the posted questions getting worse?

    Ah, okay. You've asked a question that happens to fit my editorial and writing expertise. Yes, the apps work on laptops, but yes, you still need a Kindle.

    The reason being...

    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.

  • Reply To: Are the posted questions getting worse?

    Silly question for you. Why do you need a Kindle device when you could install the Kindle or Nook app on any tablet of your choice?

    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.

  • Reply To: Insert variable values into SQL Server table

    HA! Finally got someone in corporate who had a clue and pointed me to the way to get the SqlServer module loaded outside of powershell.

    Do manual download from https://www.powershellgallery.com/packages/SqlServer/21.1.18246-preview. Save...

    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.

  • Reply To: Insert variable values into SQL Server table

    It doesn't, actually, because the output does the date in named format. "Apr 06 01:18 " for example. It's a little frustrating.

    I'll keep playing with the code and see if there'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.

  • Reply To: Insert variable values into SQL Server table

    The Invoke command looks like what I need after taking a few hours to look it over, but now the problem I'm running into is that I can't install 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.

  • Reply To: Are the posted questions getting worse?

    Spam can be very tasty given the right circumstances. I especially like turkey spam, grilled.

    @=)

    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.

  • Reply To: 2019 SSRS Install problem

    BWAHAHAHAHAHAHA... or maybe that should be WAAAAAAAAAAAAAAAHHHHHHH.

    I opened a ticket with Microsoft regarding this issue. After an entire week of back and forth (and the version of ProcMon they had...

    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.

  • Reply To: 2019 SSRS Install problem

    Well, we did get SSRS installed. We just can't create a new database or get it to restore encryption keys when we restore the 2012 ReportServer and ReportServerTempDB databases 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.

  • Reply To: SQL Server Interview Questions And Answers

    Your workplace asks some interesting questions, but anyone reading this thread should be aware that it's specific to your workplace and other employers (like my team) doesn't ask questions like...

    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.

  • Reply To: 2019 SSRS Install problem

    Our version is Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) - 15.0.4083.2 (X64)

    Nov  2 2020 18:35:09

    Copyright (C) 2019 Microsoft Corporation

    Developer Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393:...

    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.

  • Reply To: 2019 SSRS Install problem

    That link refers to SQL 2017 and apparently Microsoft had to go in and fix the installer package because the user had to re-download and use the Upgrade option.

    I'll try...

    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.

  • Reply To: 2019 SSRS Install problem

    So I'm not going to be able to directly upgrade my 2012 ReportServer database to 2019?

    And we're not going to be able to have multiple instances? That sucks and poses...

    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.

Viewing 15 posts - 241 through 255 (of 9,720 total)