Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 7,164 total)

  • RE: assigning variable to connection manager

    Now when I set up my SSIS server (And I'm a strong believer in Standalone SSIS servers)

    Agreed! SQL 2012 makes it much easier to have them too, although I have...

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

    April 11, 2012 at 4:42 pm

    #1472309

  • RE: assigning variable to connection manager

    DeusExDatum (4/11/2012)

    I totally agree opc.three; I guess it depends on why you need to change the Connection. If your looking at it from an infrastructure perspective, and it's to...

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

    April 11, 2012 at 12:42 pm

    #1472147

  • RE: Teach myself SSIS

    dwain.c (4/10/2012)

    Gotta bookmark this thread. SSIS is next on my SQL learning expedition!

    Awesome! Two outspoken anti-RBAR-advocates in one thread threatening to learn SSIS, I might fall over :hehe:

    EDIT: to...

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

    April 11, 2012 at 12:23 pm

    #1472117

  • RE: Abnormal SQL issue

    Brandie Tarvin (4/11/2012)

    opc.three (4/10/2012)

    Brandie Tarvin (4/10/2012)

    Also make sure the sa account doesn't own the jobs in question.

    Why would it matter if sa owned jobs?

    Because if sa is disabled, then scheduled...

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

    April 11, 2012 at 11:11 am

    #1472067

  • RE: SQL Alerts

    derekr 43208 (4/11/2012)

    opc.three (4/10/2012)

    I use Policy Based Management with a WMI query (ExecuteWql).

    Thanks

    Can you explaing how that works?

    Thanks

    Derek

    Sorry, I misspoke, I use PowerShell with a WMI query, not Policy Based...

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

    April 11, 2012 at 10:14 am

    #1472009

  • RE: server name after migration

    Lynn Pettis (4/11/2012)

    SQLKnowItAll (4/11/2012)

    opc.three (4/11/2012)

    sqlfriends (4/11/2012)

    ...I don't see change DNS name in the steps.

    You're unbelievable....

    LMAO You will have to work with your network admins on this one.

    Okay, who has the...

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

    April 11, 2012 at 9:37 am

    #1471975

  • RE: server name after migration

    sqlfriends (4/11/2012)

    ...I don't see change DNS name in the steps.

    You're unbelievable....

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

    April 11, 2012 at 9:24 am

    #1471965

  • RE: assigning variable to connection manager

    Using variables, expressions and command line parameters is overkill in a sense. For the record though, you can set the property of anything in the package directly using command line...

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

    April 11, 2012 at 9:04 am

    #1471933

  • RE: SQL Server 2005 Windows authetication

    sanj_love89 (4/10/2012)

    what are the setting to avoid the authetication

    or how to allow the windows authetication

    Settings for SQL server so i can allow windows authetication and the authentication not failed

    Thanxs...

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

    April 11, 2012 at 8:30 am

    #1471886

  • RE: for each loop container to loop through excel files

    Raunak Jhawar (4/11/2012)

    opc.three (4/10/2012)

    The 1TB in 30 minutes example was leveraging parallelism within SSIS. If you're using a foreach loop then you're making SSIS single-threaded. Since you have a varying...

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

    April 11, 2012 at 8:26 am

    #1471882

  • RE: Teach myself SSIS

    Any chance it turns your world inside-out and gets you away from using BULK INSERT and xp_cmdshell, and instead onto using an OLE DB Destination with fast-load and the Execute...

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

    April 10, 2012 at 5:00 pm

    #1471614

  • RE: Teach myself SSIS

    Jeff Moden (4/10/2012)

    Heh... crud. Two decent links to how to learn it. That probably means that I'm going to have to spend some time learning about it. 😛

    Whoa,...

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

    April 10, 2012 at 4:48 pm

    #1471608

  • RE: server name after migration

    SQLKnowItAll (4/10/2012)

    Perry Whittle (4/10/2012)

    sqlfriends (4/9/2012)

    So, what exactly the step you do for keeping the same name?

    rename windows server, then use sp_dropserver followed by sp_addserver.

    Note you cannot rename the instance...

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

    April 10, 2012 at 4:44 pm

    #1471606

  • RE: Modified DateTimeStamp - No Default on record creation

    Jeff Moden (4/10/2012)

    opc.three (4/9/2012)

    L' Eomot Inversé (4/9/2012)

    Jeff Moden (4/8/2012)

    I prefer they both be NOT NULL and, like Gail identified, will make both the same on INSERT. I also use...

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

    April 10, 2012 at 4:18 pm

    #1471595

  • RE: Recommendation needed for reindexing/reorganizing on multiple servers in multiple dbs

    pamozer (4/9/2012)

    Thank you. We are using Ola's scripts. We do not use replication. The multiple databases are per customer databases with one shared database.

    The one thing...

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

    April 10, 2012 at 3:46 pm

    #1471567

Viewing 15 posts - 4,516 through 4,530 (of 7,164 total)