Forum Replies Created

Viewing 15 posts - 5,746 through 5,760 (of 9,726 total)

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 5,746 through 5,760 (of 9,726 total)