Forum Replies Created

Viewing 15 posts - 91 through 105 (of 7,164 total)

  • RE: Header and Detail Data

    bpowers (5/2/2016)

    Attached is the new sample data and SSIS project I mimicked using your example. I appreciate all the help on this!

    Luckily it was a minor issue. When you select...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 7, 2016 at 11:54 am

    #1877326

  • RE: Schema Qualified object Name

    tom.groszko (5/2/2016)

    Did you ever find a PBM way to do this.

    I have been unable to find any facet that looks at code.

    The facet Multipart Name only looks at the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 2, 2016 at 8:03 pm

    #1876137

  • RE: Header and Detail Data

    If you post sample tables in the form of CREATE TABLE statements, sample data in the form of INSERT INTO statements and the SSIS Package you are working with I'll...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 26, 2016 at 8:06 pm

    #1874834

  • RE: Convert date to MMDDYYYY

    Orlando Colamatteo (4/16/2016)

    ...

    Now, interestingly enough, the same test using the built-in FORMAT function yielded similar performance to CONVERT. I am not sure if optimizations have been added but I am...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 16, 2016 at 9:11 pm

    #1872578

  • RE: Convert date to MMDDYYYY

    Orlando Colamatteo (2/10/2016)

    Ed Wagner (2/10/2016)

    Orlando Colamatteo (2/10/2016)

    Luis Cazares (2/10/2016)

    micang (2/10/2016)

    Orlando Colamatteo (2/9/2016)

    The performance of FORMAT is very poor when used over large sets of data which is unfortunate because the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 16, 2016 at 5:13 pm

    #1872570

  • RE: SQL 2012 - 2 SSIS services after upgrading from SQL 2008 R2

    Your configuration is going to be uncommon to say the least (SQL 2005 is beyond end of life). Any response on a Forum is going to be heresay from the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 14, 2016 at 8:58 pm

    #1872211

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    thebigvalbosky (4/14/2016)

    Hello - loved the article as well. I tried implementing it using 2008 R2 and i ran into the problem where this reference does not exist.

    [Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]

    I've...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 14, 2016 at 8:46 pm

    #1872210

  • RE: Tlog file full..No space to ru Backup log statement

    coolchaitu (3/29/2016)

    There is no replication or mirroring set up. How about issuing a checkpoint?

    checkpoints do not cause log truncation when in full (or bulk logged) recovery mode and a log...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 29, 2016 at 10:05 pm

    #1868464

  • RE: Two Things I Would Change in SSISDB Setup

    Practical, useful information from the front lines. These settings are analog to setting Max Memory on a new instance. They certainly caught my team and I off guard when first...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 29, 2016 at 7:32 am

    #1868223

  • RE: On formatting SQL code

    diamondgm (3/29/2016)

    TomThomson (3/28/2016)

    Eric M Russell (3/28/2016)

    The stored procedure I'm currently tasked with refactoring reads like a 20 page short story by Clive Barker.

    You have my deepest sympathy.

    I wrote some of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 29, 2016 at 1:59 am

    #1868150

  • RE: sql and stored procedure

    sqlnewbie17 (3/28/2016)

    Thanks...That is one of the solutions but was curious to know if I could do using only t-sql.

    Anyways thank you for the response.

    As I mentioned I would use SSIS...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 28, 2016 at 8:30 am

    #1867982

  • RE: On formatting SQL code

    Are you trying to incite a riot, Phil?

    In my experience (and I think IBM did some work around this that support it) a consistently formatted codebase has less bugs than...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 26, 2016 at 9:45 am

    #1867857

  • RE: More GROUP BY

    Thanks for the question.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 24, 2016 at 9:41 pm

    #1867682

  • RE: sql and stored procedure

    sqlnewbie17 (3/24/2016)

    Apologies to disappoint people on board for their 'humour'. But that is not the case.

    I need to extract the result from the stored procedure from a bunch of servers...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 24, 2016 at 9:29 pm

    #1867681

  • RE: Insert Stored Procedure Results Into New Table Without Using OPENQUERY

    william.palace (3/24/2016)

    The stored procedure presented in this article appears to be incomplete as of the time I am writing this post. The last line I can see in the textbox...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 24, 2016 at 9:26 pm

    #1867680

Viewing 15 posts - 91 through 105 (of 7,164 total)