Forum Replies Created

Viewing 15 posts - 7,516 through 7,530 (of 11,678 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/23/2012)

    anthony.green (3/23/2012)

    sorry, i think the sarcasum of the post was lost, few posts this morning which where so very very simple which could of been found via google

    I...

    March 23, 2012 at 7:01 am

    #1463341

  • RE: Store Procedure Control or Dataflow Task

    You can copy paste the contents of the script files to the Execute SQL Task. Change the SQLSourceType from File connection to Direct input and put the code in the...

    March 23, 2012 at 6:18 am

    #1463304

  • RE: SSIS to move data from SQL 2000 to SQL 2008

    It's feasible.

    You'll just have to put a bit more development effort in it.

    March 23, 2012 at 6:14 am

    #1463303

  • RE: SSIS

    The path you mention is correct. It's the path where the SSIS package is located that's being used by the job.

    However, is this job in production? Then this package is...

    March 23, 2012 at 6:06 am

    #1463302

  • RE: SSIS

    If they are on the filesystem, there should be a filepath in the job that references the package.

    The user is asking for the latest version. Are there versions stored somewhere...

    March 23, 2012 at 4:57 am

    #1463273

  • RE: Dealing with custom date formats in T-SQL

    Gianluca Sartori (3/23/2012)

    charles.southey (3/23/2012)

    If you want a commercially-supported CLR-based utility for this our SQLUtilities product includes a wide range of date formatting & parsing functions, as well as other useful...

    March 23, 2012 at 3:55 am

    #1463250

  • RE: which is faster? SSIS or SQL?

    Charmer (3/23/2012)

    SQLRNNR (3/22/2012)

    Lynn Pettis (3/22/2012)

    What do you test your code on during development? You don't have a development or test database to work with?

    Even taking the DDL from the...

    March 23, 2012 at 3:34 am

    #1463246

  • RE: looking to get first sql job

    If the overtime happens on a consistent basis, yes.

    But usually when I do some overtime I work a bit less long the day/week after.

    March 23, 2012 at 3:00 am

    #1463234

  • RE: Are the posted questions getting worse?

    anthony.green (3/23/2012)

    Koen Verbeeck (3/23/2012)

    It's you.

    Ah thanks for that, makes me feel better knowning its just a localised issue.

    Well, the local version works. If I enter google.com I'm automatically directed to...

    March 23, 2012 at 2:45 am

    #1463228

  • RE: Are the posted questions getting worse?

    It's you.

    March 23, 2012 at 2:35 am

    #1463224

  • RE: How can I get SQL Browser Service running

    The fact that you're apparently not an SSAS admin can probably cause issues with you trying to connect from Excel.

    Log into SSAS using SSMS and add yourself as one of...

    March 23, 2012 at 2:34 am

    #1463223

  • RE: SSIS-Fast Parse

    I'm curious, did the OP get the idea for this question by watching the SSIS Tips&Tricks session on the 24 hours of PASS? Josef Richberg devoted a section on FastParse.

    March 23, 2012 at 1:58 am

    #1463210

  • RE: How can I get SQL Browser Service running

    If TCP/IP is disabled it doesn't really matter.

    It's just localhost, you should be able to connect just fine.

    There must be something wrong, the problem is finding it.

    Did you install SQL...

    March 23, 2012 at 1:43 am

    #1463205

  • RE: Dealing with custom date formats in T-SQL

    Gianluca Sartori (3/23/2012)

    Thank you, Koen.

    The BOL page for CONVERT is linked in the "built-in method so far" section. unfortunately hyperlinks are not easy to spot both on the forums and...

    March 23, 2012 at 1:27 am

    #1463201

  • RE: SSIS-Fast Parse

    Very nice question about a quite unknown feature of SSIS. Thanks!

    March 23, 2012 at 1:11 am

    #1463191

Viewing 15 posts - 7,516 through 7,530 (of 11,678 total)