Forum Replies Created

Viewing 15 posts - 31 through 45 (of 3,666 total)

  • RE: SSIS 2014, how to chain execution of 3 packages

    I would create a new package executes each of these packages in the required sequence.



    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: SSIS process row

    The easiest way I can imagine doing this is by using the error output to store the rows that erred out and use that stored output as in put for...



    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: SSIS integration services not in services

    Sue_H (8/30/2016)


    Sorry no. However, if you are a member of Visual Studio Dev Essentials, the 2014 Developers edition is free to download.

    Joining Dev Essentials is free so you may...



    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: Avoiding Stored Procedures

    I think the argument against store procedure sounds a lot like someone saying we should not use screws because their preferred tool is a hammer.



    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: EXCEL destination error: Column names used more than once

    Columns are read or written in the order they are defined in the connection manager. If you're having a problem with the order, check the connection manager.



    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: EXCEL destination error: Column names used more than once

    Does the spreadsheet have column names that are used more than once?



    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?

    Luis Cazares (8/25/2016)


    Sean Lange (8/25/2016)


    Grant Fritchey (8/25/2016)


    Sean Lange (8/25/2016)


    Grant Fritchey (8/25/2016)


    Lynn Pettis (8/25/2016)


    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    I posted...



    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?

    Sean Lange (8/25/2016)


    Grant Fritchey (8/25/2016)


    Sean Lange (8/25/2016)


    Grant Fritchey (8/25/2016)


    Lynn Pettis (8/25/2016)


    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    I posted a comment....



    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 (8/25/2016)


    Alvin Ramard (8/25/2016)


    Grant Fritchey (8/25/2016)


    Lynn Pettis (8/25/2016)


    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    Holy crap. I can't wait 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: How to prevent disabled Sites in CRM from showing in SSAS

    You need to look at the process, or processes, that update/rebuild your dimensions and facts and resolve the issue there.



    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 (8/25/2016)


    Lynn Pettis (8/25/2016)


    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    Holy crap. I can't wait to hear that statistics answer...



    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: Load data using SSIS

    First thing I would try is to delete the FTP task and then try to recreate it.



    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: Create Unique identifier from text

    CELKO (8/25/2016)


    ... The purpose of GUID and UUID is to locate something that is external to the database. It is never intended for internal use inside the schema. ...

    Oh...



    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: updating a field with unique 15 digit navarchar

    Luis Cazares (8/25/2016)


    Alvin Ramard (8/25/2016)


    Would this work?

    LEFT(REPLACE(CAST(NEWID () AS NVARCHAR(MAX)), '-', '') , 15)

    I'm not sure if that will return unique strings. Although, the chance for duplicates is low.

    Good point...



    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: CALCULATING DELAY SECONDS

    JALLYKAMOZE (8/25/2016)


    Alvin Ramard (8/25/2016)


    JALLYKAMOZE (8/25/2016)


    Alvin Ramard (8/25/2016)


    It would also help if you provided us with proper information. The SQL logic you provided does not work!

    CREATE TABLE DELAYSECONDS(

    ProgramID INT, ID...



    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 - 31 through 45 (of 3,666 total)