Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: SSIS for Multiple Environments

    ryan thanks alot for the info.

    robert. are you referring to the package protection level?

    when we are in development we EncryptSensitiveWithUserKey enabling each developer to do their own thing while working...

  • RE: SSIS for Multiple Environments


    Interesting, that's how we'd like to ours to behave.

    We use SQL Agent as our job scheduler. Stopping the job step leaves a thread of dtexec running the package and it...

  • RE: SSIS for Multiple Environments

    The approach of setting an environment variable in the scope of the batch I do like. Our relative path method for configs and logs works great for a one time...

  • RE: SSIS for Multiple Environments

    This topic definitely needs more attention. It wasn't/isn't a pleasant process. So great job on laying some ground rules.

    Being able to promote smoothly through environments (4 in our case) was...

  • RE: A Special Announcement from Andy, Brian, and Steve

    The best of wishes to you guys - this site was.... nay IS .... and WILL BE my first port of call when on my SQL wanderings. Thanks for everything...

  • RE: Computer lazy after error on programming with SQL

    Restarting your web server can never hurt with this kind of thing - assuming it's not a production machine! Sounds like IIS is keeping an open thread somewhere, it might...

  • RE: Dynamic SQL or Stored Procedure

    To the debugging Shew: the sp debugger in QA is great, I've been lamenting it's absence since 6.5. Watches, param setting, breaks, autorollback - no more print.

    As for dynamic sql:...

  • RE: Query? English Query.

    Thanks very much for the link. It was a curiosity thing, definitely a neat idea.

  • RE: GROUING function


    That's is pretty much exactly what I am doing. It's for report formatting exactly, I'm using it to break out the different levels of aggregation applied by WITH ROLLUP. It's...

  • RE: GROUING function

    I'm looking the GROUPING function applied to the GROUP BY clause of my built T-SQL.

    I just need a better discussion of it than BOL has - kinda helpful but not...

Viewing 10 posts - 1 through 10 (of 10 total)