Forum Replies Created

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

  • RE: Help me

    quillis131 (6/16/2011)


    which version are you using, mine 2008

    Right there might be the source of our communication issue. I'm using 2005 and having no trouble at all. And I assumed you...

  • RE: Help me

    At this point, I would say the package is corrupt or something is wrong with your install.

    Start over with a brand new package.

  • RE: Help me

    quillis131 (6/16/2011)


    But to chage the packageScope TransactionOption to required, I need to disable the check point property SaveCheckpoints : False, other wise it doesn't allow me to change from supported...

  • RE: Are the posted questions getting worse?

    jcrawf02 (6/16/2011)


    Found my entertainment for the forseeable future. As provided to me:

    "You HAVE to click this link …. It is a video name generator and gives you new (made up)...

  • RE: Help me

    Why do you have the container and the task TransactionOption set to two different things?

    Package Level should be Required, not Supported.

    The other two can be (probably should be) Supported.

    Currently,...

  • RE: SQL Server Database Architecture

    If I got questions like that (phrased exactly like that), I would have to refer them to Books Online and the multitude of SQL Server books saying "I can't explain...

  • RE: Select query help

    Another is to do an INNER JOIN to a subquery for the CustID and MAX(EndDate), joined on both fields.

    A third method would be to put the above subquery into a...

  • RE: Help me

    Can you post some pictures?

    I'm looking for the following images:

    Control Flow

    Package level properties (all)

    Container level properties (all)

    Outside task level properties (all)

    We're having a communications disconnect and I think it...

  • 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...

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