Results 1 to 4 of 4

Thread: BCP problem

  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: BCP problem

    Hi All,
    This is ulagu.
    I need a clarification regarding BCP usage.
    I have written Stor Proc which will write output data file using BCP.The problem is,when I execute the entire Stor Proc statements the output file is written with 6 records and when I use "exec SPName" it creates only 4 records.
    Can anyone help me in this why it shows difference in output data file.

    Thanks,
    ulagu.kumar

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    The error is clearly on line 17 of your stor proc.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2010
    Posts
    2
    Ya..It 's exactly in line 17.It works fine now..Good job dude..

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Treatment of nulls could be different between the two connection types. Do you have any statements that compare data to NULL?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •