Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 3,666 total)

  • RE: Use Execute SQL Task Or Use a available SSIS task to build package.

    saurabh.deshpande (10/6/2010)


    1. I tried both the way, on performance front EXECUTE SQL Task is

    good as compared to DATA Flow’s.

    ...



    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/6/2010)


    Stefan Krzywicki (10/6/2010)


    Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

    That sentence is WAY too long:

    Wow, loading data into Access is a Royal...



    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: Parse name from Email Address

    Look at the CHARINDEX function and combine it with the LEFT, or SUBSTRING, function.



    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?

    Stefan Krzywicki (10/6/2010)


    Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.

    LOL

    I haven't had to face that yet so I can't comment, well, looks like I...



    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: Use Execute SQL Task Or Use a available SSIS task to build package.

    You can do it either way. I'd encourage you to try it both way just to see how well each one performs.

    Also, ask yourself this question: "Why one...



    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?

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


    I just checked. Almost everything in the db for forums is an int, so we're fine.

    As an FYI, we have about 5GB of data in...



    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?

    CirquedeSQLeil (10/6/2010)


    How about the myth about DBCC Timewarp?

    What myth? 😀



    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: SQL Server 2008 R2 10.5 Developer Edition Free Download

    Hughesy (10/6/2010)


    OK. Thanks guys for the posts, I meant bundled with Enterprise for example on the MSDN licence.

    Do you happen to know if there are any changes to the Integration...



    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?

    Chris Morris-439714 (10/6/2010)


    Somehow, for reasons long ago forgotten, Post Count has been set up as the unusual datatype NUMERIC(6,0).

    Steve, didn't you tell us a while back that it was a...



    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?

    Stefan Krzywicki (10/6/2010)


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


    Stefan Krzywicki (10/6/2010)


    Alvin Ramard (10/6/2010)


    Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close 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: Can one send mail task be used for multiple packages

    goodluck (10/6/2010)


    Hi,

    Can we use one send mail task for multiple packages in SSIS thru SQL Server table Configurations. Please let me know how ?

    Thanks

    A task can only exist in one...



    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: Insert ID from CSV File

    Soulfly73 (10/6/2010)


    Hello all,

    First of all I think this is one $%^of a forum, tons of information and I thank you for that 🙂

    I have a question, I'm importing data from...



    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?

    Alvin Ramard (10/6/2010)


    Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to each other.

    Look to the left of any post 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: User::Variable not being updated in an SSIS Package

    Jim Covington (10/5/2010)


    I need to get access to a package variable to use in the steps of my ssis package.

    I have created the Variables as type String and a scope...



    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: Difference between Informatica & SSIS.

    It's true that informatica comes with more built in features but, assuming you will be running SSIS on an existing SQL Server, it also comes with a much higher price...



    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,546 through 1,560 (of 3,666 total)