Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 9,725 total)

  • RE: SSIS package creation with txt file having multiple select statements

    below86 (3/21/2016)


    And if you don't have the rights to create the SP on the server?

    I presume the company in question would have an SDLC process to move something from Dev...

    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.

  • RE: Are the posted questions getting worse?

    Luis Cazares (3/21/2016)


    Eirikur Eiriksson (3/21/2016)


    Brandie Tarvin (3/21/2016)


    For those of you with standing desks, ArsTechnica says it may not be helping[/url] you at all.

    Here is an alternative[/url]

    😎

    Now, that's a great idea....

    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.

  • RE: Are the posted questions getting worse?

    For those of you with standing desks, ArsTechnica says it may not be helping[/url] you at all.

    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.

  • RE: SSIS package creation with txt file having multiple select statements

    manoj.kumar-1078069 (3/17/2016)


    2) Loop over the record set and store each query in a variable

    Depending on how big the query is, this may not work. Variables in SSIS have 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.

  • RE: SSIS package creation with txt file having multiple select statements

    below86 (3/16/2016)


    Brandie Tarvin (3/15/2016)


    aavi1011 (3/14/2016)


    App team provided select statements and want output of select statement as report in xls or csv format to thier email ID

    Is this a one off...

    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.

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/15/2016)


    JustMarie (3/15/2016)


    Steve Jones - SSC Editor (3/15/2016)


    I'm sad today

    One bit of advice. Work with your body shop to make sure that the repairs come under...

    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.

  • RE: Are the posted questions getting worse?

    Can someone help over on this thread? I'm positive the OP needs to rebuild SQL Server, but he seems certain that his backup strategy works and that the issue is...

    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.

  • RE: Are the posted questions getting worse?

    GilaMonster (3/15/2016)


    Ed Wagner (3/15/2016)


    GilaMonster (3/15/2016)


    Brandie Tarvin (3/15/2016)


    In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is...

    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.

  • RE: SSIS package creation with txt file having multiple select statements

    aavi1011 (3/15/2016)


    Yes I know,But creating Sp's in production,DBA need to get more permissions,Need to take this to other level.

    It sounds as if you've never used Data Flow Tasks given your...

    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.

  • RE: SSIS package creation with txt file having multiple select statements

    aavi1011 (3/15/2016)


    This need to happen daily.

    Do you know how to create an SSIS 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.

  • RE: SSIS package creation with txt file having multiple select statements

    aavi1011 (3/14/2016)


    App team provided select statements and want output of select statement as report in xls or csv format to thier email ID

    Is this a one off run or something...

    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.

  • RE: Are the posted questions getting worse?

    In a change of subject, anyone else find it odd that someone would claim that the proper way of doing a SQL thing is a workaround and not a working...

    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.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (3/14/2016)


    Brandie Tarvin (3/14/2016)


    Eirikur Eiriksson (3/12/2016)


    Brandie Tarvin (3/11/2016)


    What a wonderful day in the upgrade-hood...

    Sigh.

    So many SSIS packages to upgrade. So. Many. PACKAGES! :crazy:

    Baggages?

    😎

    😛

    Still not sure if I 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.

  • RE: Cannot drop the table 'TABLE' because at least part of the table resides on an offline filegroup.

    Leeland (3/14/2016)


    To get around this, I did have an actual full restore done on another server which wasn't being used at this time so I went through the process of...

    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.

  • RE: Potential presentation idea: The role of documentation in disaster recovery

    Also consider the need for roles during DR. Who is responsible for what tasks is critical to ensure everything gets up and running on time without duplicate effort.

    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 - 1,966 through 1,980 (of 9,725 total)