Forum Replies Created

Viewing 15 posts - 6,736 through 6,750 (of 13,879 total)

  • 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

  • RE: SQL Code QA

    colin.dunn (9/7/2016)

    Good Afternoon All, This is my first post.

    I created the below code and if works fine. However my DBA said "It does the job but is clunky" how could...

    September 7, 2016 at 6:20 am

    #1899536

  • RE: Weird - When creating a table, it changes the schema to domain/user... but only for one group?

    Bill (DBAOnTheGo) (9/6/2016)

    We have a group that when they have SA, it creates all tables as dbo.table. This makes sense since SA makes them default to dbo. When we remove...

    September 6, 2016 at 1:49 pm

    #1899459

  • RE: Are the posted questions getting worse?

    The history is interesting to some, but the OCD with names is just rubbish.

    He may be OCD with names, yet he still managed to misspell Jeff's.

    September 6, 2016 at 8:01 am

    #1899340

  • RE: String Match Help

    Thom A (9/5/2016)

    Phil Parkin (9/5/2016)

    I'm planning to use function to remove spaces, quotes and "JR" , is there any function already exists?.so I can reuse same else I will start...

    September 5, 2016 at 8:54 am

    #1899206

  • RE: String Match Help

    I'm planning to use function to remove spaces, quotes and "JR" , is there any function already exists?.so I can reuse same else I will start fresh one.

    Not specifically. I...

    September 5, 2016 at 8:24 am

    #1899203

  • RE: String Match Help

    koti.raavi (9/5/2016)

    I have two tables joining based on Member ID and Member Name. My question is do we have any function like lookup in ssis

    Ex:

    Table1

    ...

    September 5, 2016 at 7:52 am

    #1899198

  • RE: restore catalog db from one server to another

    Not even then. Instead, export the packages from SSISDB, put them into VS projects and build/deploy from there.

    September 2, 2016 at 8:28 pm

    #1899071

  • RE: Debuging SSIS Script Component In Visual Studio

    Ok, I'm away from my PC right now, so can't check details.

    Have you tried creating a brand new solution/project and adding a new package to it? Just to rule out...

    September 1, 2016 at 10:47 am

    #1898834

Viewing 15 posts - 6,736 through 6,750 (of 13,879 total)