Forum Replies Created

Viewing 15 posts - 3,661 through 3,675 (of 7,164 total)

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    Thank you for reading the article and for posting these questions.

    kpatrick (7/2/2012)


    Some questions to consider:

    1. What kind of Windows Server security permissions does the identity running the SSIS package...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SSIS pacage run history

    Here is a very handy tool (no cash outlay and open source) to add logging to any SSIS package without modifying the code:

    DTLoggedExec[/url]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: backup thread in a wiat state for the last 2 days.

    You're welcome. I am happy it was all sorted without a major incident!

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: backup thread in a wiat state for the last 2 days.

    How are you getting along?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    Shaun-884394 (7/2/2012)


    This is a nice solution. However when we have hundred other files for similar process it will eventually lock a considerable memory forever.

    I was thinking of having split the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    Charmer (7/2/2012)


    I cleared the previous issue..but again i have come across with the folloeing where i don't have any idea of it...

    [WMI Event Watcher Task] Error: Watching for the Wql...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    Raunak Jhawar (7/2/2012)


    Orlando, just 3 words...

    Simple. Lucid. Clear.

    Thanks for the compliment Raunak, that is exactly what I was going for.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: data pump into MySQL

    @cmoy,

    You posted in a SSIS 2005 forum, but you said you were taking data from a 2008 database. Did you post in the wrong forum or are you really...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: How Can I Update Data From An Email Attachment ?

    clucasi (7/2/2012)


    No, the work around was to write script that extracts the attachment and saves the file to a folder, its a bit clunky and doesn't always work, I have...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Moving sql users to new domain

    From ALTER LOGIN

    The new name of the login that is being renamed. If this is a Windows login, the SID of the Windows principal corresponding to the new name must...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: data pump into MySQL

    CozyRoc (7/1/2012)


    The bulk-load API is not related to MySQL. It is ODBC-based API, which uses the low-level ODBC handles and functions. If you are C++ programmer, I'm talking about similar...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: data pump into MySQL

    CozyRoc (6/29/2012)


    Another over-rated comment, without much meaning. Installation of properly done third-party library takes 2 mins. Another 5 mins are required to license it. So the whole process will take...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Moving sql users to new domain

    Indianrock (7/1/2012)


    Our users will be migrating to a new domain. The sql servers will not ( for now ). My research so far indicates either 1) nothing will...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: data pump into MySQL

    CozyRoc (6/29/2012)


    I disagree. It is included in the product so does not require a cash outlay.

    The solution you present requires extra cash outlay in the contractor pocket who is doing...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: data pump into MySQL

    CozyRoc (6/29/2012)


    opc.three (6/29/2012)


    Here is an example for you. It requires no third party components and modification of only a few lines of VB.net code to get working with your chosen...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 3,661 through 3,675 (of 7,164 total)