Forum Replies Created

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

  • 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

  • RE: restore catalog db from one server to another

    You should leave the catalog db alone and simply redeploy the packages.

    September 1, 2016 at 1:49 am

    #1898697

  • RE: Debuging SSIS Script Component In Visual Studio

    Which version of SSDT are you using?

    September 1, 2016 at 1:45 am

    #1898696

  • RE: mdf database in sql server

    valmostricay (8/31/2016)

    Thank you guys, for help, unfortunately my problem connected with sql server.

    As were our replies, whose questions you have not responded to.

    August 31, 2016 at 8:57 am

    #1898577

  • RE: SSIS process row

    coool_sweet (8/31/2016)

    sorry type mistake, suppose i have 41 rows ,20 processed successfully and 21th got error.

    now when next time my package run i want it to start fro 22 rows...

    August 31, 2016 at 8:33 am

    #1898561

  • RE: SSIS process row

    coool_sweet (8/31/2016)

    I have 60 rows ,SSIS processed 20 rows and 21 rows got error, now I want my package to run from taking 22 rows .

    how to do in ssis

    As...

    August 31, 2016 at 5:41 am

    #1898505

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