Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 9,707 total)

  • RE: Using SSIS

    psc032802 (12/5/2014)

    Yes, I see the viewer installed on my computer.

    I do not have much access overall. Just read access to one database and I cannot see what...

    December 5, 2014 at 11:43 am

    #1763051

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/5/2014)

    Brandie Tarvin (12/5/2014)

    GilaMonster (12/5/2014)

    And crisis, panic, run around screaming, the EF-based app is slow.

    600MB database, generating 5GB of trace data in 1 hour....

    Here's a bit of easy...

    December 5, 2014 at 5:31 am

    #1762931

  • RE: Using SSIS

    psc032802 (12/4/2014)

    Thanks for the good info. If data profile tasks is all I need, then I ask the DBA to have it run on regular schedule. If they...

    December 5, 2014 at 4:52 am

    #1762917

  • RE: Are the posted questions getting worse?

    GilaMonster (12/5/2014)

    And crisis, panic, run around screaming, the EF-based app is slow.

    600MB database, generating 5GB of trace data in 1 hour....

    Here's a bit of easy code to solve the...

    December 5, 2014 at 4:48 am

    #1762916

  • RE: SQL DBA knowing user passwords

    Eric M Russell (12/4/2014)

    I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public permissions, can...

    December 4, 2014 at 7:24 am

    #1762706

  • RE: SQL DBA knowing user passwords

    Ville-Pekka Vahteala (12/3/2014)

    ScottPletcher (12/2/2014)

    eric.notheisen (12/2/2014)

    In our company sharing user passwords is a firing offense. As developers needing to troubleshoot user defined defects, we restore the production database to our...

    December 4, 2014 at 6:05 am

    #1762691

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    Your number 3 option should work for me:

    3) Ask to have the SQL Server client tools installed on your machine (including BIDS) and create the package yourself. Ask...

    December 3, 2014 at 10:18 am

    #1762458

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    thanks for replying me again. if I ask my dba to install BIDS on machine, what do you think he'll be concerned about? security? my skill/knowledge of SSIS?

    I...

    December 3, 2014 at 9:57 am

    #1762452

  • RE: Using SSIS

    psc032802 (12/3/2014)

    I am not a DBA. Not a developer either. More of an end user of the data typically analyzing it.

    I'm mostly interested in the data profile task...

    December 3, 2014 at 9:56 am

    #1762451

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    i used to be able to use DTS to transfer data from source to destination in sql 2000. now we upgraded to sql 2008r2, my previlige is deprived....

    December 3, 2014 at 9:41 am

    #1762447

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    thank you. before i ask my dba to install BIDS on my machine, is there any free version that i can play around first?

    BIDS is part of the...

    December 3, 2014 at 9:39 am

    #1762446

  • RE: Using SSIS

    jliu 81028 (12/3/2014)

    i have a similiar question: i have SSMS 2008r2. Our database server has SSIS installed. I want to view the packages. Do i need to...

    December 3, 2014 at 9:23 am

    #1762436

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/3/2014)

    Jack Corbett (12/3/2014)

    SQLRNNR (12/2/2014)

    Chad Crawford (12/2/2014)

    Stefan Krzywicki (12/2/2014)

    How do you view the queries it generates? Are they persisted somewhere? Do you just see them through Perfmon?...

    December 3, 2014 at 7:55 am

    #1762395

  • RE: Using SSIS

    Brandie Tarvin (12/2/2014)

    psc032802 (12/2/2014)

    if the packages are to be run against a single database/server, then it would be best to install ssis on that same machine, correct?

    then bids/ssis needs to...

    December 3, 2014 at 4:00 am

    #1762302

  • RE: Using SSIS

    psc032802 (12/2/2014)

    if the packages are to be run against a single database/server, then it would be best to install ssis on that same machine, correct?

    then bids/ssis needs to be installed...

    December 2, 2014 at 12:37 pm

    #1762204

Viewing 15 posts - 3,016 through 3,030 (of 9,707 total)