Forum Replies Created

Viewing 15 posts - 6,721 through 6,735 (of 13,876 total)

  • RE: SQL Code QA

    david.wright-948385 (9/8/2016)

    Phil Parkin (9/8/2016)

    I disagree. It makes perfect sense. He *always puts ON clauses on separate indented lines* – perfectly consistent.

    That's the point I'm making - it's consistent, but no...

    September 8, 2016 at 6:10 am

    #1899765

  • RE: Load few tabs from excel

    abhas (9/8/2016)

    Hi Philip,

    I am able to load all tabs but how to load the tabs whose name format is : 1Q17, 4Q16,3Q16 etc.

    Thanks,

    Abhas.

    To import data from one or more named...

    September 8, 2016 at 6:06 am

    #1899762

  • RE: UDF - Is Transaction Control possible?

    Maybe you could make use of two or more SEQUENCEs. Take a read of this and see whether it could be of help.

    September 8, 2016 at 5:47 am

    #1899757

  • RE: SQL Code QA

    david.wright-948385 (9/8/2016)

    drew.allen (9/7/2016)

    I always put my ON clauses on a separate indented line, because I want to keep it consistent. I treat short and long JOIN clauses the same,...

    September 8, 2016 at 5:41 am

    #1899753

  • RE: SQL Code QA

    mister.magoo (9/7/2016)

    Phil Parkin (9/7/2016)

    One thing missing from SQL Prompt, however, is the ability to change between 'my' settings (whatever works for the individual) and 'company' settings (the common format). I'd...

    September 7, 2016 at 1:51 pm

    #1899667

  • RE: SQL Code QA

    Luis Cazares (9/7/2016)

    Jason A. Long (9/7/2016)

    Speaking for all the jerk code reviewers of the world... Yes, formatting counts, yes I'll give you crap over it (when you have to...

    September 7, 2016 at 1:23 pm

    #1899661

  • RE: Dynamic Connection String Passed Through C#

    Kyle Sherry (9/7/2016)

    Not a bad suggestion which I might try next. I came across this article which might address a solution. It looks promising. I'll post update if this works...

    September 7, 2016 at 10:59 am

    #1899632

  • RE: Load few tabs from excel

    abhas (9/7/2016)

    Hello all,

    Hope all are doing good! 🙂

    I am having a excel sheet which will contains around 20-24 tabs. Among those tabs i need to load data whose tab...

    September 7, 2016 at 10:20 am

    #1899618

  • RE: Dynamic Connection String Passed Through C#

    Kyle Sherry (9/7/2016)

    I'm trying to create an interface that a user can select an environment to execute a package against (development, sandbox or staging) and when they select an environment...

    September 7, 2016 at 10:19 am

    #1899617

  • RE: Changing destination csv filename

    Brad Allison (9/7/2016)

    I guess I don't understand, but each month it runs, it would be a unique file name. So next month it should be something like 20161001.csv. ...

    September 7, 2016 at 8:26 am

    #1899590

  • RE: UDF - Is Transaction Control possible?

    NewbyUser (9/7/2016)

    Hi everybody,

    i have a problem with a scalar valued function. There are two systems who will use the function to create new "OrderNumbers".

    Sometimes the two system use the function...

    September 7, 2016 at 8:25 am

    #1899589

  • RE: Changing destination csv filename

    Koen Verbeeck (9/7/2016)

    Brad Allison (9/7/2016)

    Is it as simple as doing this: System.IO.File.Move(@"C:\From.txt", @"C:\TO.txt"); ?

    Except I need the "TO.txt" file to be YYYYMMDD.csv

    Yes, but be aware that the Move method cannot...

    September 7, 2016 at 8:10 am

    #1899585

  • RE: Changing destination csv filename

    Or if you are happy writing some C# and using a Script Task (my preference), it takes only three or four lines of code. I can provide an example if...

    September 7, 2016 at 6:51 am

    #1899557

  • RE: SQL Code QA

    colin.dunn (9/7/2016)

    Thanks for the info guys, I've been learning SQL for a while now and I want to get my scripts as effective as possible.

    No problem. Keep posting your questions...

    September 7, 2016 at 6:36 am

    #1899545

  • RE: Changing destination csv filename

    It's probably easier to leave the destination file name as is and add a subsequent task to do a copy/rename.

    If you do a search on SSIS file system task rename...

    September 7, 2016 at 6:34 am

    #1899542

Viewing 15 posts - 6,721 through 6,735 (of 13,876 total)