Forum Replies Created

Viewing 15 posts - 5,731 through 5,745 (of 9,707 total)

  • RE: Help me

    quillis131 (6/16/2011)


    one container and one task ( script ) outside the container. Check points are enabled on container and Script task. Am I clear???...let me know

    Yes, that's clear. Thank you....

  • RE: SSIS Error Code DTS_E_PRODUCTLEVELTOOLOW

    Phil Parkin (6/16/2011)


    Ah indeed. OK, try this one (it's a big page, search for fuzzy and you'll find it towards the end of the page).

    Ahha! There we go. Thanks for...

  • RE: SSIS Error Code DTS_E_PRODUCTLEVELTOOLOW

    radb4u, My previous post is not saying Phil is wrong. Generally, these things don't change between editions. But I have yet to find the pudding to find the proof that...

  • RE: Today's Random Word!

    Daniel Bowlin (6/16/2011)


    Brandie Tarvin (6/16/2011)


    Brandie Tarvin


    Pneumonoultramicroscopicsilicovolcanoconiosis

    SQLRNNR (6/15/2011)


    Now what does it mean?

    It's a lung disease caused by silica.

    But can you pronounce it?

    Sure. Pneumonoultramicroscopicsilicovolcanoconiosis.

    If you didn't hear me, it's because your...

  • RE: Get Source Location From a Table.

    Elliott Whitlow (6/16/2011)


    To perform the moves of the files.. Did I miss something (entirely possible 🙂 )..

    That's why I advised a combination of Execute SQL (to load the variables)...

  • RE: sql script in ssis package using variables

    Glad we could help.

    Just remember, in SQL Server, there are redundant methods of accomplishing 1 task. So if you're stuck, ask for the alternatives.

  • RE: SSIS Error Code DTS_E_PRODUCTLEVELTOOLOW

    Phil Parkin (6/16/2011)


    Brandie Tarvin (6/16/2011)


    Phil Parkin (6/15/2011)


    You need SQL Server Enterprise Edition to use fuzzy lookup.

    Phil, where did you get the idea that fuzzy lookup is only available to Enterprise...

  • RE: sql script in ssis package using variables

    sonal_anjaria (6/16/2011)


    Could you elaborate a bit more about the input output wizard, i am quite new at ssis and under a tight deadline

    In SSMS, open a connection to your Production...

  • RE: Missing Drive where SQL Server instance installed - Urgent help required

    If you have issues in the restore because of the lack of tail logs, let us know and we'll try and figure it out from there. But go ahead and...

  • RE: Batch alter stored procedure within one single transaction with error handling

    GilaMonster (6/16/2011)


    Brandie Tarvin (6/16/2011)


    Try naming the Transaction. See if that gets around the error.

    Naming transactions does just about nothing. It's a documentation thing (with one minor exception)

    I admit. That...

  • RE: sql script in ssis package using variables

    Elliott Whitlow (6/16/2011)


    Use the input/output wizard and chose the tables and at the end save the package that should give you 98% of the work and be a lot faster...

  • RE: sql script in ssis package using variables

    Elliott is correct on this one. Not only is SELECT...INTO going to cause you performance issues, but the use of * will also. Can I ask why you don't just...

  • RE: Help me

    Okay, I'm a little confused. Could you speak less in L33T / text shorthand and more in real English words, please?

    How many containers do you have in your package? If...

  • RE: Get Source Location From a Table.

    Elliott Whitlow (6/16/2011)


    Brandie Tarvin (6/16/2011)


    Why use a Script Task when a File System Task might work just as well? You can set variables at the package level and have them...

  • RE: SSIS Error Code DTS_E_PRODUCTLEVELTOOLOW

    Phil Parkin (6/15/2011)


    You need SQL Server Enterprise Edition to use fuzzy lookup.

    Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available...

Viewing 15 posts - 5,731 through 5,745 (of 9,707 total)