Forum Replies Created

Viewing 15 posts - 46 through 60 (of 107 total)

  • RE: Question w.r.t. amount columm

    Steve Jones - SSC Editor - Monday, December 4, 2017 9:22 AM

    It would be good to see more information, even mocked up.

    Is...

  • RE: Date format check

    sqlenthu 89358 - Sunday, November 12, 2017 10:29 PM

    Hello all,
    I have few records in a table. And I want to check if...

  • RE: Bulk load architecture

    sqlenthu 89358 - Thursday, October 26, 2017 11:30 PM

    Jeff Moden - Thursday, October 26, 2017 9:10 PM

  • RE: Bulk load architecture

    Jeff Moden - Thursday, October 26, 2017 9:10 PM

    sqlenthu 89358 - Thursday, October 26, 2017 6:47 AM

  • RE: Bulk load architecture

    Also is there a way to handle UNC path configuration as source folder for picking up files to be loaded ? From my local path, package works wonder.

  • RE: Bulk load architecture

    Hi guys, I was able to create SSIS package to load multiple files in a folder. Now could you please direct me on how to put dynamic columns value population...

  • RE: Options to run BCP in SQL Server

    Jeff Moden - Tuesday, October 10, 2017 11:22 AM

    sqlenthu 89358 - Tuesday, October 10, 2017 11:17 AM

  • RE: Options to run BCP in SQL Server

    Guys, I am little confused here w.r.t. permissions. When I tried BCP load from my local disk using that login and password, data load happened. But when I am using...

  • RE: Bulk load architecture

    Apologies to not clarify earlier but there will be only latest files in that directory i.e. the ones which need to be processed.

  • RE: Bulk load architecture

    Is SSIS as efficient as bulk load commands ? I am asking as performance will be a big test here. There will be almost 20-30 files with size varying from...

  • RE: Options to run BCP in SQL Server

    Seems the account doesn't have bulkadmin access. I am checking if I can get that. In between I have one architecture level question based on bulk uload of files. Creating...

  • RE: BCP upload from a txt file

    Sorry for the late update everyone. Had not been a good time for me health wise. I was able to figure out what was the issue. One of the column...

  • RE: BCP upload from a txt file

    Anyone any insight on this please?

  • RE: BCP upload from a txt file

    David Burrows - Monday, August 7, 2017 8:25 AM

    SQLNCHAR indicates Unicode (2 bytes per char)
    Therefore the host file data length need to...

  • RE: BCP upload from a txt file

    David Burrows - Monday, August 7, 2017 7:42 AM

    Make sure line 24 in your format file has "\r\n" as a terminator
    Check your input...

Viewing 15 posts - 46 through 60 (of 107 total)