Forum Replies Created

Viewing 15 posts - 1,576 through 1,590 (of 3,666 total)

  • RE: Non-Uniform Text File

    Steve Hindle-535638 (10/5/2010)


    One more question on this...

    As I split the records up from the original file, the detail records need to have some information from their header records appended to...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Incorrect syntax near '0'.

    Derrick Smith (10/5/2010)


    Shouldn't it be something like

    INSERT INTO INVOICES

    VALUES (xx,xx,xx,xx)

    There is no Values or Select in your statement...I've never tried without it but I would imagine that would throw an...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Avoid Character Limit in Send Mail Task BCC Field

    lk-681111 (10/5/2010)


    That's what I thought. I just need a way to get around that; this email has the potential to have to go out to over 100 people, so 256...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/5/2010)


    Steve Jones - SSC Editor (10/5/2010)


    I see this a lot, even with authors. People think you are following along with them, or they don't realize they're skipping...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Incorrect syntax near '0'.

    tmurray 69699 (10/5/2010)


    if you look at the set up of mycommand in the first part of my post I have ending paren after conn2.

    When I go into immediate window and...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Incorrect syntax near '0'.

    tmurray 69699 (10/5/2010)


    I have ending ) after the , conn2). Tried putting it after the last '0'"), conn2 but it through up error about missing paren

    It's not in the text...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Avoid Character Limit in Send Mail Task BCC Field

    There's a 256 character limit on the email address fields.

    http://technet.microsoft.com/en-us/library/ms142165(SQL.90).aspx



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Incorrect syntax near '0'.

    Where's your closing parentheses that should be near the last '0'?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Avoid Character Limit in Send Mail Task BCC Field

    The first thing I would check is if the string is being cut as it comes out of the database table. Is it possible you're using a SQL variable...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Is it time to implement some sort of entrance exam for SSC? After reading the question I actually spent a few minutes staring at the screen thinking "What .......?...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Run 64 bit SSIS package from sql job agent

    pwalter83 (10/5/2010)


    Hello Friends,

    I want to run the 64 bit SSIS package from the SQL job agent. I understand I need to select 'Operating System (CmdExec)' as the Job 'Type'. ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Roll up all SSIS errors to single email

    wcwarner (9/16/2010)


    Hello,

    I have a very simple pkg that truncates a table and pumps fresh data into the table nightly. I have been able to capture the errors in an event...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: File System Task Expressions

    The issue here might fall under the classification of undocumented feature, if you know what I mean.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: File System Task Expressions

    Brandie Tarvin (10/5/2010)


    ... I confirmed this issue with Brian Knight, BTW. He says that Expressions in the File System Task don't work the way I wanted them to work and...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Paul White NZ (10/4/2010)


    jcrawf02 (10/4/2010)


    Paul White NZ (10/2/2010)


    Maybe, but you wouldn't have envied me and Justin carrying a sofa and six-burner BBQ up the stairs this morning. Comedy.

    You should...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 1,576 through 1,590 (of 3,666 total)