Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 7,164 total)

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    Brandt Smith (10/25/2012)


    nice work...any way you could apply this technique to a SharePoint list view? I use them frequently as a 'queue' for gathering information and then use SSIS (with...

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

  • RE: WMI task and WQL query

    Hopefully one of the three techniques will work for you.

    Using the Script Task in SSIS to Process Data Files When They Arrive[/url]

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

  • RE: Today's Random Word!

    George M Parker (10/25/2012)


    READ_COMMITTED_SNAPSHOT

    optimistic

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

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    Stan Kulp-439977 (10/25/2012)


    This is a great idea, but in my particular case our sysadmin will not allow the dot net framework to be installed on his SQL Servers because of...

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

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    dave-dj (10/25/2012)


    excellent and comprehensive article.

    I only have a couple of questions..

    first - if you where required to process multiple files per day, would you adapt this process, or would you...

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

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    andre.pageot (10/25/2012)


    Excellent use of SSIS

    however I did spot a potential bottleneck, you could potentially get stuck in loop if the process that held the file open has halted or crashed...

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

  • RE: Using the Script Task in SSIS to Process Data Files When They Arrive

    zapallina (10/25/2012)


    This is my first post ever so yea herewe go... let me say thanks for such an amazing and complete step by step post.

    I just came across with this...

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

  • RE: Today's Random Word!

    crookj (10/24/2012)


    Daniel Bowlin (10/24/2012)


    Y2K memories

    All Niter! Test! Test! and Retest! More fear than reality.

    ALTER TABLE dbo.MY_TABLE ALTER COLUMN SOME_DATE CHAR(8) NOT NULL; -- widen CHAR(6) so the world does...

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

  • RE: Login Resolution To Wrong Domain Account

    Good to know, thanks for posting back the resolution.

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

  • RE: Redesign help

    Eric M Russell (10/23/2012)


    What's described above would be one form of a "property bag" technique. I have been tasked with building data extract and reporting from a large ISV database...

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

  • RE: WMI task and WQL query

    When adding a file to the drop directory are you copying and pasting the file into an otherwise empty directory? WMI is quite particular in that if you rename an...

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

  • RE: Redesign help

    Eric M Russell (10/23/2012)


    Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below, each...

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

  • RE: Redesign help

    Steven Willis (10/23/2012)


    opc.three (10/22/2012)


    This is just a pared-down example of a method used by one of the largest open-source development platforms in existence.

    And that platform would be...care to share?

    DotNetNuke

    DotNetNuke...

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

  • RE: WMI task and WQL query

    The demo was done using SSIS 2012 so establish a baseline using the demo exactly as it was implemented, then change it for your environment.

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

  • RE: WMI task and WQL query

    What about my second question?

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

Viewing 15 posts - 2,866 through 2,880 (of 7,164 total)