Forum Replies Created

Viewing 15 posts - 1,456 through 1,470 (of 3,666 total)

  • RE: change the values while tranforming

    You could use a conditional split followed by as many derived columns as you need.



    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?

    The Dixie Flatline (10/12/2010)


    Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.

    Just lay them on the table and proceed...



    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: Difficulty exporting table

    Donalith (10/12/2010)


    Derrick,

    Unfortunately, we've grown out of control on the production database (happened before I came on board) and we can't replicate it due to storage issues.

    Alvin,

    How do you export 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: Difficulty exporting table

    How are you doing the export?

    Have you tried doing this in batches instead of the whole table at 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: IF Statement within a SSIS Package

    AndrewSQLDBA (10/12/2010)


    Hello Everyone

    What would be the Best way to create an IF statement within a SSIS Package?

    I am wanting to fire off a SQL Task, if the Day of the...



    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: change the values while tranforming

    preensheen (10/12/2010)


    Hi All,

    Is it possible to chage the values while transforming the values in SSIS. For example...I have bit values coming from database..say 0 & 1 and need display...



    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 Database - data coming from three different systems

    Find out why you have duplicates in your sample data. Is it because you of bad sample date? Will the real production data also have duplicates?

    The answers 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 Increase Size of Log Files

    I've seen one company cycle the logs files on every server everynight at midnight. This made searching the logs much easier that trying to do it with a log...



    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: Error handling on destination OLEDB destination task

    chetan.v (10/12/2010)


    .... I beleive this is the problem when we set Fast-Load option.

    No, SSIS is trying to commit a batch of records at a time. If any...



    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: Sorting data files before merge join

    Michael Valentine Jones (10/12/2010)


    Since the source of data is a TXT file created with BCP, why don't you just order the TXT file in the order you want by using...



    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: Product level insufficient for component Fuzzy Lookup

    steveb. (10/12/2010)


    Deepthy (10/12/2010)


    Thanks for reply, but dtexec and dtexecui are giving the same error

    Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient 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: Sorting data files before merge join

    Phil Parkin (10/12/2010)


    Alvin Ramard (10/12/2010)


    --

    One thing for sure, it wouldn't be fast.

    I'd like to nominate this comment for UNDERSTATEMENT OF THE DAY 😀

    No argument there. I'm trying 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: Sorting data files before merge join

    I'm not suggesting this as a way to sort big files. This is just an idea for a bit of fun.

    I wonder if there's a way to implement 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: Backup/Detach/Restore

    Donalith (10/11/2010)


    Thank you so much for your help!

    I'm going to go with the detach, copy, and reattach. That'll leave a viable database on the first server while I'm working on...



    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?

    GSquared (10/11/2010)


    If you can do it to a bagel, can you also do it to 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]

Viewing 15 posts - 1,456 through 1,470 (of 3,666 total)