Forum Replies Created

Viewing 15 posts - 61 through 75 (of 117 total)

  • 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...

  • RE: BCP upload from a txt file

    David Burrows - Monday, August 7, 2017 5:46 AM

    That is what is causing the error, either remove the spaces or put quotes...

  • RE: BCP upload from a txt file

    David Burrows - Monday, August 7, 2017 4:39 AM

    As a guess, if you posted part of the file you are using, I would...

  • RE: BCP upload from a txt file

    Hi David. That's a wonderful solution to get results with where clause. However i an stuck at a situation. The number of columns in data file and in format file...

  • RE: Formatting in HTML table

    Thom A - Wednesday, July 19, 2017 4:30 AM

    sqlenthu 89358 - Wednesday, July 19, 2017 4:17 AM

  • RE: Formatting in HTML table

    Thom A - Wednesday, July 19, 2017 2:34 AM

    sqlenthu 89358 - Wednesday, July 19, 2017 2:29 AM

Viewing 15 posts - 61 through 75 (of 117 total)