Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 7,164 total)

  • RE: Powershell Proponents - A Question for You

    Brandie Tarvin (6/7/2012)


    I would like to be able to use Powershell from within SSIS to do things like file management (without having to have xp_cmdshell enabled). The sort of things...

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

  • RE: MSSQL 2012 versus 2008...2000

    roy.tollison (5/3/2012)


    my original post explained it

    in mssql 2008 or lower that command worked without having to setup sysmessages for it. in 2012 it no longer works. i originally had written...

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

  • RE: Running Windows batch script

    In PowerShell you can invoke cmd.exe directly with a /c and you can use Test-Path to check for the existence of a file.

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

  • RE: Create SSIS package in SQL SERVER 2012 for SQL SERVER 2008

    Koen Verbeeck (6/7/2012)


    opc.three (6/6/2012)


    The marketing material says you can, but I have not tried it so could not say how accurate the claims are.

    I don't think you can create a...

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

  • RE: Transactional Replication

    Suresh B. (6/6/2012)


    jitendra.padhiyar (6/6/2012)


    Hello Guys,

    I setup transactional replication and come to konw that the table with primary key is only accepted for Transactional replication.

    I dont konw why.. Can anyone...

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

  • RE: Low disk space alert

    Jeff Moden (6/6/2012)


    As always, you're a gentleman and a scholar, Orlando. Thanks for talking about this. There will always be some disagreement between thee and me on these...

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

  • RE: Config File in SQL Server Database

    gravitysucks (6/6/2012)


    opc.three (6/5/2012)


    The use of a table is in lieu of a file. Have a look at the link I posted. It explains all the types of package configs.

    I have...

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

  • RE: Ruuning Update Stats

    inHouseDBA (6/6/2012)


    Thank you,

    I guess my stopping point is the following:

    When you rebuild the index - you rebuild it with 100% sample size, but when you run sp_updatestats a default...

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

  • RE: Low disk space alert

    Jeff Moden (6/6/2012)


    Funny... you left out an important part of that. The sentence immediately before what you referenced says...

    A custom in-process OLE server that is created by using Microsoft...

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

  • RE: Create SSIS package in SQL SERVER 2012 for SQL SERVER 2008

    The marketing material says you can, but I have not tried it so could not say how accurate the claims are.

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

  • RE: Export multiple record layouts to one flat file...

    Is SSIS an option? It is built to make tasks like this relatively simple.

    This thread runs down the issue for someone else in your situation fairly well.

    Creating Header AND...

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

  • RE: Low disk space alert

    opc.three (6/6/2012)


    Perry Whittle (6/6/2012)


    Where as I just use wmi from a central instance

    What do you use to check the results of the call to wmic you posted, and to send...

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

  • RE: Low disk space alert

    Perry Whittle (6/6/2012)


    Where as I just use wmi from a central instance

    What do you use to check the results of the call to wmic you posted, and to send an...

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

  • RE: Troubleshooting SSIS package

    The Replay Trace will capture everything. I would setup the package to use a unique Application Name in the connection string so I could filter on that in the Trace...

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

  • RE: Low disk space alert

    Perry Whittle (6/6/2012)


    You'll need to use xp_fixeddrives to get the free space and disk name

    Well, someone may. I use PowerShell + WMI for disk space monitoring and I check all...

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

Viewing 15 posts - 3,841 through 3,855 (of 7,164 total)