Forum Replies Created

Viewing 15 posts - 1 through 15 (of 3,232 total)

  • RE: Add only changed or new rows to table

    Another question in addition to Phil's...will your target table be updated by anything outside of this process?  For example, will other processes or a users be able to update this...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 16, 2017 at 1:31 pm

    #1968427

  • RE: Create Table with appropriate Data Types based on flat file

    Use the Data Import Wizard.  Set it up to read from your flat file with the correct delimiter, then on the Advanced tab, press the 'Suggest Types' button.  This will...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 9, 2017 at 12:04 pm

    #1967444

  • RE: Upgrade Advisor Errors

    Thanks Lowell, I'll check that tonight as well.  I should have brought my laptop with me today!

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 8, 2017 at 12:11 pm

    #1941659

  • RE: Upgrade Advisor Errors

    I'll have to go back and check on the .NET framework.  It's a Windows 10 laptop, 64-bit.  I'm pretty sure I've got the right .NET framework as I'm running Visual...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    May 8, 2017 at 11:50 am

    #1941653

  • RE: SSIS --Taking ID from destination table to copying the same in the another destination table

    Sounds like a package with two data flows. In your first data flow, load the master table. In the second data flow, load the child data, but look...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 3, 2017 at 7:22 am

    #1920366

  • RE: the promotion has decided to go out with a bang

    reported as spam

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 30, 2016 at 10:58 am

    #1920137

  • RE: early weigh-in results: Rousey hits 135, Hendricks pablinaerer

    reported as spam

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 30, 2016 at 10:56 am

    #1920134

  • RE: Insert or replace?

    You don't need the replace function here. Simply set the Description value to your desired value (in this case, accountID + description)

    update c

    set [Description] = t.accountid...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 9, 2016 at 7:30 am

    #1917063

  • RE: DBA without sa rights???

    huh, I'm in downtown Fort Worth! Looks like we're almost neighbors. Do you want to do DBA work, web development, etc? There are technical recruiting firms here...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 8, 2016 at 11:36 am

    #1916879

  • RE: DBA without sa rights???

    Time to start looking...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 8, 2016 at 8:53 am

    #1916814

  • RE: Different Environment for different datasources

    I would recommend going with straight up Package parameters to set these. If you are on 2012 and greater, consider using SSIS environments. Here's a walk-through. I...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 1, 2016 at 12:15 pm

    #1915549

  • RE: Output the Results of T-SQL Query to an e-mail attachment and/ or Body

    I assume this is from Integration Services? If so, use a data flow to put the query results in a file (with your format of choice) and then use...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    December 1, 2016 at 12:09 pm

    #1915546

  • RE: SSIS Packages --> 2 questions

    Guessing that the DTS.Runtime library is referencing the local SSIS instance. Not sure how you'd point that to another catalog. You may check the class properties to see...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 23, 2016 at 10:32 am

    #1914285

  • RE: Trigger causing deadlocks

    Consider changing your design. I prefer to not persist this type of value in my data. A view would be a great way to expose the 'IsActive' value...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 21, 2016 at 7:35 am

    #1913705

  • RE: SSIS Packages --> 2 questions

    In addition to what Phil gave you for question #1, you say you want an easy user interface for execution packages? What about SQL Agent? Why not set...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    November 21, 2016 at 7:23 am

    #1913698

Viewing 15 posts - 1 through 15 (of 3,232 total)