bcpin

• faizal.h

  SSC Enthusiast

  Points: 185

  More actions

  March 8, 2009 at 11:25 pm

  #206755

  Hi,

  Please help me in bcp in the below data structure to the data base ...

  feb2009SMART/SMARTSMART/SMART89810000005USD13224.18feb 2009 GCN & Telex MIS ChargeOutOUCGB2833OUCZ14040

  feb2009SMART/SMARTSMART/SMART89810000003USD18.75feb 2009 GCN & Telex MIS ChargeOutOUCGB2833OUCZ14040

  feb2009SMART/SMARTSMART/SMART89810000004USD71.51feb 2009 GCN & Telex MIS ChargeOutOUCGB2833OUCZP1073

  feb2009SMART/SMARTSMART/SMART89810000005USD1358.61feb 2009 GCN & Telex MIS ChargeOutOUCGB2833OUCZP1073

  feb2009USDDAUSD/0010990765US00001/000000000789810000001USD1.80feb 2009 GCN & Telex Cash ChargeOutGB00002/0000GB2833

  feb2009USDDAUSD/0010990765US00001/000000036489810000001USD25.67feb 2009 GCN & Telex Cash ChargeOutGB00002/0000GB2833

  feb2009USDDAUSD/0010990765US00001/000000050789810000001USD10.00feb 2009 GCN & Telex Cash ChargeOutGB00002/0000GB2833

  feb2009USDDAUSD/0010990765US00001/000000067689810000001USD0.57feb 2009 GCN & Telex Cash ChargeOutGB00002/0000GB2833

  feb2009USDDAUSD/0010990765US00001/000000067989810000001USD13782.07feb 2009 GCN & Telex Cash ChargeOutGB00002/0000GB2833

  feb2009USDDAUSD/0010990765US00001/000000067989810000002USD51.38feb 2009 GCN & Telex Cash ChargeOutGB00002/0000GB2833

  The column names of the table should be ..

  1) Billing Cycle

  2) SVC Provider Org Code

  3) Customer Org Code

  4) Sub Product

  5) Transaction Currency Code

  6) Actual Cost

  7) Volume

  8) Invoice Description

  9) Other SVC Provider Org Code

  10) Other Cust Org Code

  11) Additional Info

  Thanks in advance,

  Faizal Ahmed.H

• Jan Van der Eecken

  SSCrazy Eights

  Points: 9029

  More actions

  March 17, 2009 at 3:27 pm

  #961429

  Hi Faizal,

  In order to assist you, it would be most helpful if you could provide a DDL script that creates your table, as well as a sample input file (as an attachment) that contains the data you listed. From your post it is totally unclear what the delimiters between the columns are or even where the delimiters are supposed to be. By the way, why are you storing dates as "feb2009", i.e. as a string? Is that how the data comes in from an external system? I sincerely hope you don't store it in SQL in that format. Will be a futile attempt trying to extract this data in a decently sorted fashion once it is on the server. OK, it can be done, but performance will suck.

  Regards,

  Jan

  --------------------------------------------------------------------------
  A little knowledge is a dangerous thing (Alexander Pope)
  In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]