Forum Replies Created

Viewing 15 posts - 3,046 through 3,060 (of 9,728 total)

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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?...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2014 at 12:37 pm

    #1762204

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/2/2014)

    We are all anti-RBAR, but I would bet at some point early in our careers we wrote RBAR code because we didn't know better, I know...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2014 at 11:46 am

    #1762190

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/2/2014)

    Brandie Tarvin (12/2/2014)

    I feel for you, Gail. We're going 'round and 'round with our corporate tech department.

    Us: We need a SQL Server 2012 deployment with X instances in this...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2014 at 8:33 am

    #1762112

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/2/2014)

    SQLRNNR (12/2/2014)

    <sarcasm>EFW is the bomb and must be worshiped because it saves certain dev types a ton of time to develop. </sarcasm>

    And reading that makes me want...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2014 at 8:25 am

    #1762102

  • RE: Are the posted questions getting worse?

    I feel for you, Gail. We're going 'round and 'round with our corporate tech department.

    Us: We need a SQL Server 2012 deployment with X instances in this configuration, which is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 2, 2014 at 8:15 am

    #1762093

  • RE: SQL DBA knowing user passwords

    Been on PTO for a week, so didn't catch up to this thread until now...

    Regarding the app that doesn't prompt for SQL password changes, depending on how big your company...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 1, 2014 at 11:48 am

    #1761827

  • RE: Using SSIS

    psc032802 (12/1/2014)

    the end users in this scenario are people wanting to run the data profiling features. my original question was what needs to be installed and where does it...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    December 1, 2014 at 11:39 am

    #1761822

Viewing 15 posts - 3,046 through 3,060 (of 9,728 total)