BCP-Numeric Value out of Range (Network Steve Forum)

BCP-Numeric Value out of Range

I'm exporting out a number of tables via BCP for our Cognos group to report on. Almost all tables can export and import successfully. I'm using the following command to export out:

SET OUTPUT=K:\BCP_FIN_Test
SET ERRORLOG=K:\BCP_FIN_Test\BCP_Error_Log
SET TIMINGS=K:\BCP_FIN_Test\BCP_Timings

bcp "SELECT TOP 100 * FROM FS84RPT.dbo.PS_VOUCHER Inner Join FS84RPT.[dbo].[PS_VCHR_ACCTG_LINE] on PS_VOUCHER.VOUCHER_ID= PS_VCHR_ACCTG_LINE.VOUCHER_ID and PS_VOUCHER.BUSINESS_UNIT = PS_VCHR_ACCTG_LINE.BUSINESS_UNIT WHERE PS_VCHR_ACCTG_LINE.FISCAL_YEAR = '2014' and PS_VCHR_ACCTG_LINE.ACCOUNTING_PERIOD BETWEEN '9' AND '11' " queryout %OUTPUT%\PS_VOUCHER.txt -e %ERRORLOG%\PS_VOUCHER.err -o %TIMINGS%\PS_VOUCHER.txt -T -N

The Query returns data fine in a SQL editor. We have tried exporting/importing both with Native and Character settings.

Below is the errors on import:

Here is the table structure:

Column/Type/Computer/Length

BUSINESS_UNIT char no 5
VOUCHER_ID char no 8
VOUCHER_LINE_NUM int no 4
TOTAL_DISTRIBS int no 4
MAX_DISTRIB_LINE int no 4
BUSINESS_UNIT_PO char no 5
PO_ID char no 10
LINE_NBR int no 4
SCHED_NBR smallint no 2
DESCR char no 30
DESCR254_MIXED char no 254
MERCHANDISE_AMT decimal no 13
MERCH_AMT_BSE decimal no 13
ITM_SETID char no 5
INV_ITEM_ID char no 18
QTY_VCHR decimal no 9
STATISTIC_AMOUNT decimal no 9
UNIT_OF_MEASURE char no 3
UNIT_PRICE decimal no 9
FRGHT_PRORATE_FLG char no 1
DSCNT_APPL_FLG char no 1
ERROR_FLAG char no 1
PROCESS_INSTANCE decimal no 9
WTHD_SW char no 1
TAX_CD_VAT char no 8
VAT_RECOVERY_PCT decimal no 5
FINAL_REF_IND char no 1
BUSINESS_UNIT_RECV char no 5
RECEIVER_ID char no 10
RECV_LN_NBR int no 4
RECV_SHIP_SEQ_NBR smallint no 2
MATCH_LINE_OPT char no 1
DISTRIB_MTHD_FLG char no 1
VCHR_AMT_FORCE_FLG char no 1
AMT_ONLY_FLG char no 1
TXN_CURRENCY_CD char no 3
BASE_CURRENCY char no 3
CURRENCY_CD char no 3
VAT_TXN_TYPE_CD char no 4
ECTRANSID char no 15
ECQUEUEINSTANCE int no 4
ECTRANSINOUTSW char no 1
SHIPTO_ID char no 10
SUT_BASE_ID char no 10
TAX_CD_SUT char no 8
ULTIMATE_USE_CD char no 8
SUT_EXCPTN_TYPE char no 1
SUT_EXCPTN_CERTIF char no 20
SUT_APPLICABILITY char no 1
WTHD_SETID char no 5
WTHD_CD char no 5
NATURE_OF_TXN1 char no 1
NATURE_OF_TXN2 char no 1
VAT_APPLICABILITY char no 1
VAT_USE_ID char no 6
VAT_ENTITY char no 20
BUSINESS_UNIT_RTV char no 5
RTV_ID char no 10
RTV_LN_NBR int no 4
FISCAL_REGIME char no 2
GEO_CODE char no 11
MATCH_LINE_STATUS char no 1
CNTRCT_ID char no 25
CNTRCT_LINE_NBR int no 4
RELEASE_NBR int no 4
BUS_UNIT_RELATED char no 5
VOUCHER_ID_RELATED char no 8
VENDOR_ID char no 10
SPEEDCHART_KEY char no 10
RECEIPT_DT PSDATE no 8
INSPECT_DT PSDATE no 8
VAT_LN_ENT_AMT decimal no 13
VAT_LN_ENT_AMT_BSE decimal no 13
VAT_MBASIS_AMT decimal no 13
VAT_MBASIS_AMT_BSE decimal no 13
USER_VCHR_CHAR1 char no 1
USER_VCHR_CHAR2 char no 1
USER_VCHR_DEC decimal no 13
USER_VCHR_DATE PSDATE no 8
USER_VCHR_NUM1 smallint no 2
VNDR_LOC char no 10
USER_LINE_CHAR1 char no 1
USER_SCHED_CHAR1 char no 1

Appreciate replies.

April 18th, 2015 4:23am

What is this big number represents, if it belongs to int column that will break because its bigger than max int size 2,147,483,647

what you can do is try create your query to return column by column and see where its breaking then you can compare datatypes. Also you can add header to the output file by using union all:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/868e67c5-e4ab-4328-a4c0-480a81dbae4b/bcp-queryout-with-column-name-in-output?forum=transactsql

Free Windows Admin Tool Kit Click here and download it now

April 18th, 2015 5:02am

With the information you have all I can provide is guessworks. All I see is the query you use to export the data, and informal (and incomplete) definition of a table, which I don't know if it is the target table, or the resulting source table from your query.

The reasonable guess is that the definition of th esource and target table do not match. For instance a column which is decimal(9, 2) in the source is only decimal(5, 2) in the target table, and there are values >= 1000 in the source data.

For more accurate help, we would need to see the CREATE TABLE statements for the two source tables as well as the target table. We would also need to see the BCP command you use to import the file. If you use any format file, we need to see this one as well.

April 18th, 2015 5:05am

Thanks for your replies. I don't know what the import statement being used as that was done by another user. However I did run a similar query to export, which brought about a different error when trying to import.

Here are the details:

BCP Export Statement:
bcp "SELECT PS_VOUCHER.* FROM FS84RPT.dbo.PS_VOUCHER as PS_VOUCHER Inner Join FS84RPT.dbo.PS_VCHR_ACCTG_LINE as PS_VCHR_ACCTG_LINE on PS_VOUCHER.VOUCHER_ID= PS_VCHR_ACCTG_LINE.VOUCHER_ID and PS_VOUCHER.BUSINESS_UNIT = PS_VCHR_ACCTG_LINE.BUSINESS_UNIT WHERE (FISCAL_YEAR = (SELECT MAX(OPEN_YEAR_TO) FROM FS84RPT.dbo.PS_FIN_OPEN_PERIOD where [BUSINESS_UNIT] < '00200' AND [LEDGER_GROUP] = 'ACTUALS' AND TRANSACTION_TYPE = 'DEF' AND PSFT_PRODUCT = 'GL')) OR (FISCAL_YEAR = (SELECT MAX(OPEN_YEAR_TO) -1 FROM FS84RPT.dbo.PS_FIN_OPEN_PERIOD where [BUSINESS_UNIT] < '00200' AND [LEDGER_GROUP] = 'ACTUALS' AND TRANSACTION_TYPE = 'DEF' AND PSFT_PRODUCT = 'GL') AND ACCOUNTING_PERIOD > (SELECT MAX([OPEN_PERIOD_TO]) - 3 FROM FS84RPT.dbo.PS_FIN_OPEN_PERIOD where [BUSINESS_UNIT] < '00200' AND [LEDGER_GROUP] = 'ACTUALS' AND TRANSACTION_TYPE = 'DEF' AND PSFT_PRODUCT = 'GL')) " queryout %OUTPUT%\PS_VOUCHER.txt -o %ERRORLOG%\PS_VOUCHER.err -o %TIMINGS%\PS_VOUCHER.txt -T -c

Create Table Scripts (for both tables):

PS_VOUCHER SOURCE TABLE (FROM RPT)

USE [FS84RPT]
GO

/****** Object: Table [dbo].[PS_VOUCHER] Script Date: 04/18/2015 10:27:46 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PS_VOUCHER](
[BUSINESS_UNIT] [char](5) NOT NULL,
[VOUCHER_ID] [char](8) NOT NULL,
[VOUCHER_STYLE] [char](4) NOT NULL,
[INVOICE_ID] [char](30) NOT NULL,
[ERS_INV_SEQ] [smallint] NOT NULL,
[INVOICE_DT] [dbo].[PSDATE] NULL,
[VENDOR_SETID] [char](5) NOT NULL,
[VENDOR_ID] [char](10) NOT NULL,
[VNDR_LOC] [char](10) NOT NULL,
[ADDRESS_SEQ_NUM] [smallint] NOT NULL,
[GRP_AP_ID] [char](10) NOT NULL,
[ORIGIN] [char](3) NOT NULL,
[OPRID] [char](30) NOT NULL,
[VCHR_TTL_LINES] [int] NOT NULL,
[CLOSE_STATUS] [char](1) NOT NULL,
[ENTRY_STATUS] [char](1) NOT NULL,
[ACCOUNTING_DT] [dbo].[PSDATE] NULL,
[POST_VOUCHER] [char](1) NOT NULL,
[POST_STATUS_AP] [char](1) NOT NULL,
[PROCESS_INSTANCE] [decimal](10, 0) NOT NULL,
[BUSINESS_UNIT_GL] [char](5) NOT NULL,
[PROCESS_MAN_CLOSE] [char](1) NOT NULL,
[DST_CNTRL_ID] [char](10) NOT NULL,
[DUP_INVOICE_STATUS] [char](1) NOT NULL,
[VOUCHER_ID_RELATED] [char](8) NOT NULL,
[GROSS_AMT] [decimal](26, 3) NOT NULL,
[GROSS_AMT_BSE] [decimal](26, 3) NOT NULL,
[TXN_CURRENCY_CD] [char](3) NOT NULL,
[RT_TYPE] [char](5) NOT NULL,
[RATE_MULT] [decimal](15, 8) NOT NULL,
[RATE_DIV] [decimal](15, 8) NOT NULL,
[BASE_CURRENCY] [char](3) NOT NULL,
[DSCNT_AMT] [decimal](26, 3) NOT NULL,
[DSCNT_AMT_BSE] [decimal](26, 3) NOT NULL,
[DSCNT_PRORATE_FLG] [char](1) NOT NULL,
[TAX_EXEMPT] [char](1) NOT NULL,
[USETAX_AMT] [decimal](26, 3) NOT NULL,
[USETAX_AMT_BSE] [decimal](26, 3) NOT NULL,
[USETAX_PRORATE_FLG] [char](1) NOT NULL,
[SALETX_AMT] [decimal](26, 3) NOT NULL,
[SALETX_AMT_BSE] [decimal](26, 3) NOT NULL,
[SALETX_PRORATE_FLG] [char](1) NOT NULL,
[VAT_INV_AMT] [decimal](26, 3) NOT NULL,
[VAT_INV_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_NONINV_AMT] [decimal](26, 3) NOT NULL,
[VAT_NONINV_AMT_BSE] [decimal](26, 3) NOT NULL,
[FREIGHT_AMT] [decimal](26, 3) NOT NULL,
[FREIGHT_AMT_BSE] [decimal](26, 3) NOT NULL,
[MISC_AMT] [decimal](26, 3) NOT NULL,
[MISC_AMT_BSE] [decimal](26, 3) NOT NULL,
[FRGHT_PRORATE_FLG] [char](1) NOT NULL,
[DUE_DT] [dbo].[PSDATE] NULL,
[DSCNT_DUE_DT] [dbo].[PSDATE] NULL,
[PYMNT_CNT_MAX] [int] NOT NULL,
[PYMNT_CNT_TOTAL] [int] NOT NULL,
[PYMNT_TERMS_CD] [char](5) NOT NULL,
[ENTERED_DT] [dbo].[PSDATE] NULL,
[LAST_UPDATE_DT] [dbo].[PSDATE] NULL,
[TIME_EDIT] [dbo].[PSTIME] NULL,
[VCHR_TEMPLATE_ID] [char](10) NOT NULL,
[VCHR_TMPLTE_DESCR] [char](30) NOT NULL,
[WTHD_ADJUST_FLG] [char](1) NOT NULL,
[WTHD_FISCAL_YR] [smallint] NOT NULL,
[POST_STATUS_WTHD] [char](1) NOT NULL,
[ERROR_FLAG] [char](1) NOT NULL,
[VAT_BASIS_AMT] [decimal](26, 3) NOT NULL,
[VAT_BASIS_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_CALC_AMT] [decimal](26, 3) NOT NULL,
[VAT_ENTRD_AMT] [decimal](26, 3) NOT NULL,
[VAT_RCVRY_AMT] [decimal](26, 3) NOT NULL,
[VAT_RCVRY_AMT_BSE] [decimal](26, 3) NOT NULL,
[MATCH_ACTION] [char](1) NOT NULL,
[MATCH_STATUS_VCHR] [char](1) NOT NULL,
[BCM_HDR_STATUS] [char](1) NOT NULL,
[BCM_TRAN_TYPE] [char](2) NOT NULL,
[MERCHANDISE_AMT] [decimal](26, 3) NOT NULL,
[MERCH_AMT_BSE] [decimal](26, 3) NOT NULL,
[IN_PROCESS_FLG] [char](1) NOT NULL,
[MANUAL_CLOSE_DT] [dbo].[PSDATE] NULL,
[CNTRCT_ID] [char](25) NOT NULL,
[REMIT_ADDR_SEQ_NUM] [smallint] NOT NULL,
[CUR_RT_SOURCE] [char](1) NOT NULL,
[DSCNT_AMT_FLG] [char](1) NOT NULL,
[DUE_DT_FLG] [char](1) NOT NULL,
[VCHR_APPRVL_FLG] [char](1) NOT NULL,
[BUSPROCNAME] [char](30) NOT NULL,
[APPR_RULE_SET] [char](30) NOT NULL,
[APPR_CHECK_FLG] [char](1) NOT NULL,
[APPR_STATUS] [char](1) NOT NULL,
[APPR_INSTANCE] [int] NOT NULL,
[OPRID_LAST_UPDT] [char](30) NOT NULL,
[VAT_DCLRTN_POINT] [char](1) NOT NULL,
[VAT_CALC_TYPE] [char](1) NOT NULL,
[VAT_ENTITY] [char](20) NOT NULL,
[VAT_TXN_TYPE_CD] [char](4) NOT NULL,
[TAX_CD_VAT] [char](8) NOT NULL,
[VAT_RCRD_INPT_FLG] [char](1) NOT NULL,
[VAT_RCRD_OUTPT_FLG] [char](1) NOT NULL,
[VAT_RECOVERY_PCT] [decimal](5, 2) NOT NULL,
[VAT_CALC_GROSS_NET] [char](1) NOT NULL,
[VAT_RECALC_FLG] [char](1) NOT NULL,
[VAT_CALC_FRGHT_FLG] [char](1) NOT NULL,
[VAT_NRCVR_PRO_FLG] [char](1) NOT NULL,
[VAT_NRCVR_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_NRCVR_AMT] [decimal](26, 3) NOT NULL,
[VAT_CALC_AMT_BSE] [decimal](26, 3) NOT NULL,
[ECTRANSID] [char](15) NOT NULL,
[ECQUEUEINSTANCE] [int] NOT NULL,
[ECTRANSINOUTSW] [char](1) NOT NULL,
[VAT_RGSTRN_SELLER] [char](12) NOT NULL,
[MISC_PRORATE_FLG] [char](1) NOT NULL,
[COUNTRY_VAT_BILLFR] [char](3) NOT NULL,
[COUNTRY_VAT_BILLTO] [char](3) NOT NULL,
[COUNTRY_SHIP_TO] [char](3) NOT NULL,
[COUNTRY_VAT_RPTG] [char](3) NOT NULL,
[VAT_DCMNT_ID] [int] NOT NULL,
[SALETX_CALC_AMT] [decimal](26, 3) NOT NULL,
[SALETX_CLC_AMT_BSE] [decimal](26, 3) NOT NULL,
[DOC_TYPE] [char](8) NOT NULL,
[DOC_SEQ_DATE] [dbo].[PSDATE] NULL,
[DOC_SEQ_NBR] [char](12) NOT NULL,
[DOC_SEQ_STATUS] [char](1) NOT NULL,
[VOUCHER_TYPE] [char](1) NOT NULL,
[VNDR_TMPLTE_FLG] [char](1) NOT NULL,
[VAT_TREATMENT_PUR] [char](3) NOT NULL,
[VAT_EXCPTN_TYPE] [char](1) NOT NULL,
[VAT_EXCPTN_CERTIF] [char](20) NOT NULL,
[COUNTRY_SHIP_FROM] [char](3) NOT NULL,
[VAT_USE_ID] [char](6) NOT NULL,
[VAT_REBATE_AMT] [decimal](26, 3) NOT NULL,
[VAT_REBATE_AMT_BSE] [decimal](26, 3) NOT NULL,
[IST_TXN_FLG] [char](1) NOT NULL,
[LC_ID] [char](12) NOT NULL,
[REVALUE_FLAG] [char](1) NOT NULL,
[BUDGET_HDR_STATUS] [char](1) NOT NULL,
[BUDGET_MISC_STATUS] [char](1) NOT NULL,
[KK_TRAN_OVER_FLAG] [char](1) NOT NULL,
[KK_TRAN_OVER_OPRID] [char](30) NOT NULL,
[KK_TRAN_OVER_DTTM] [dbo].[PSDATETIME] NULL,
[PREPAID_REF] [char](10) NOT NULL,
[PREPAID_AUTO_APPLY] [char](1) NOT NULL,
[SBI_DOC_OPT] [char](1) NOT NULL,
[BUSINESS_UNIT_PO] [char](5) NOT NULL,
[RECV_ONLY_MTCH_FLG] [char](1) NOT NULL,
[PO_ID] [char](10) NOT NULL,
[ERS_TAX_TYPE] [char](1) NOT NULL,
[ERS_TYPE] [char](1) NOT NULL,
[INV_RECPT_DT] [dbo].[PSDATE] NULL,
[PACKSLIP_NO] [char](22) NOT NULL,
[RECEIPT_DT] [dbo].[PSDATE] NULL,
[SHIP_DATE] [dbo].[PSDATE] NULL,
[PAY_TRM_BSE_DT_OPT] [char](1) NOT NULL,
[TERMS_BASIS_DT] [dbo].[PSDATE] NULL,
[UNMTCH_PAY_FLG] [char](1) NOT NULL,
[UNMTCH_PAY_STATUS] [char](1) NOT NULL,
[VCHR_SRC] [char](4) NOT NULL,
[VCHR_SYSGEN_FLG] [char](1) NOT NULL,
[MEMO_AMT] [decimal](26, 3) NOT NULL,
[MEMO_AMT_BSE] [decimal](26, 3) NOT NULL,
[PAY_AMT] [decimal](26, 3) NOT NULL,
[PAY_AMT_BASE] [decimal](26, 3) NOT NULL,
[SBI_FLG] [char](1) NOT NULL,
[SBI_IN_PROCESS_FLG] [char](1) NOT NULL,
[SBI_NUM] [char](40) NOT NULL,
[SBI_PROCESS_ID] [decimal](10, 0) NOT NULL,
[DELETE_DT] [dbo].[PSDATE] NULL,
[CURRENCY_RPTG] [char](3) NOT NULL,
[VAT_RPTG_CURR_FLG] [char](1) NOT NULL,
[RATE_MULT_VAT] [decimal](15, 8) NOT NULL,
[RATE_DIV_VAT] [decimal](15, 8) NOT NULL,
[VAT_INV_AMT_RPTG] [decimal](26, 3) NOT NULL,
[VAT_TRANS_AMT_RPTG] [decimal](26, 3) NOT NULL,
[VAT_DCLRTN_DT] [dbo].[PSDATE] NULL,
[VAT_DCLRTN_DT_SRC] [char](1) NOT NULL,
[VAT_CALC_MISC_FLG] [char](1) NOT NULL,
[LC_EXTRCT_STATUS] [char](1) NOT NULL,
[EIN_FEDERAL] [char](9) NOT NULL,
[EIN_STATE_LOCAL] [char](20) NOT NULL,
[TAX_GRP] [char](4) NOT NULL,
[TAX_PYMNT_TYPE] [char](5) NOT NULL,
[VAT_ADVPAY_FLG] [char](1) NOT NULL,
[VAT_ROUND_RULE] [char](1) NOT NULL,
[VAT_TRANS_AMT] [decimal](26, 3) NOT NULL,
[VAT_TRANS_AMT_BSE] [decimal](26, 3) NOT NULL,
[WTHD_PREPAY_OPT] [char](1) NOT NULL,
[VAT_CF_ANLSYS_TYPE] [char](1) NOT NULL,
[VAT_NRCVR_CHRG_CD] [char](10) NOT NULL,
[VAT_RPTG_CURR_CTRL] [char](1) NOT NULL,
[IMAGE_REF_ID] [char](12) NOT NULL,
[IMAGE_DATE] [dbo].[PSDATE] NULL,
[PAY_SCHEDULE_TYPE] [char](3) NOT NULL,
[VCHR_POADJ_OPT] [char](1) NOT NULL,
[VCHR_MTCH_ADJ_OPT] [char](1) NOT NULL,
[INTERUNIT_ERR_FLG] [char](1) NOT NULL,
[VCHR_BAL_ERR_FLG] [char](1) NOT NULL,
[INSPECT_DT] [dbo].[PSDATE] NULL,
[DATE_CALC_BASIS] [char](1) NOT NULL,
[BASIS_DATE] [dbo].[PSDATE] NULL,
[PO_RECPT_DT] [dbo].[PSDATE] NULL,
[MTCH_LEVEL_STATUS] [char](1) NOT NULL,
[MTCH_LEVEL_OPT] [char](1) NOT NULL,
[MATCH_OVERRIDE] [char](1) NOT NULL,
[INVOICE_RCPT_DT] [dbo].[PSDATE] NULL,
[USER_VCHR_CHAR1] [char](1) NOT NULL,
[USER_VCHR_CHAR2] [char](1) NOT NULL,
[USER_VCHR_DEC] [decimal](26, 3) NOT NULL,
[USER_VCHR_DATE] [dbo].[PSDATE] NULL,
[USER_VCHR_NUM1] [smallint] NOT NULL,
[DESCR254_MIXED] [char](254) NOT NULL,
[DOC_TOL_HDR_STATUS] [char](1) NOT NULL,
[USER_HDR_CHAR1] [char](1) NOT NULL,
[VNDR_AFFILIATE] [char](5) NOT NULL
) ON [PRIMARY]

SET ANSI_PADDING OFF
GO

PS_VCHR_ACCTG_LINE SOURCE TABLE (RPT)

USE [FS84RPT]
GO

/****** Object: Table [dbo].[PS_VCHR_ACCTG_LINE] Script Date: 04/18/2015 10:30:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PS_VCHR_ACCTG_LINE](
[BUSINESS_UNIT] [char](5) NOT NULL,
[VOUCHER_ID] [char](8) NOT NULL,
[UNPOST_SEQ] [smallint] NOT NULL,
[APPL_JRNL_ID] [char](10) NOT NULL,
[POSTING_PROCESS] [char](4) NOT NULL,
[PYMNT_CNT] [int] NOT NULL,
[VOUCHER_LINE_NUM] [int] NOT NULL,
[DISTRIB_LINE_NUM] [int] NOT NULL,
[DST_ACCT_TYPE] [char](4) NOT NULL,
[CF_BAL_LINE_NUM] [decimal](10, 0) NOT NULL,
[LEDGER] [char](10) NOT NULL,
[TAX_AUTHORITY_CD] [char](3) NOT NULL,
[ACCOUNT] [char](10) NOT NULL,
[ALTACCT] [char](10) NOT NULL,
[DEPTID] [char](10) NOT NULL,
[STATISTICS_CODE] [char](3) NOT NULL,
[FOREIGN_AMOUNT] [decimal](26, 3) NOT NULL,
[FOREIGN_CURRENCY] [char](3) NOT NULL,
[RT_TYPE] [char](5) NOT NULL,
[RATE_MULT] [decimal](15, 8) NOT NULL,
[RATE_DIV] [decimal](15, 8) NOT NULL,
[MONETARY_AMOUNT] [decimal](26, 3) NOT NULL,
[QTY_VCHR] [decimal](15, 4) NOT NULL,
[STATISTIC_AMOUNT] [decimal](15, 2) NOT NULL,
[JRNL_LN_REF] [char](10) NOT NULL,
[DESCR] [char](30) NOT NULL,
[MERCHANDISE_AMT] [decimal](26, 3) NOT NULL,
[MERCH_AMT_BSE] [decimal](26, 3) NOT NULL,
[DSCNT_AMT_BSE] [decimal](26, 3) NOT NULL,
[SALETX_AMT_BSE] [decimal](26, 3) NOT NULL,
[USETAX_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_INV_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_NONINV_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_RCVRY_AMT_BSE] [decimal](26, 3) NOT NULL,
[FREIGHT_AMT_BSE] [decimal](26, 3) NOT NULL,
[CHART_EDIT_STATUS] [char](1) NOT NULL,
[ACCOUNTING_DT] [dbo].[PSDATE] NULL,
[ACCOUNTING_PERIOD] [smallint] NOT NULL,
[FISCAL_YEAR] [smallint] NOT NULL,
[BUSINESS_UNIT_GL] [char](5) NOT NULL,
[JOURNAL_ID] [char](10) NOT NULL,
[JOURNAL_DATE] [dbo].[PSDATE] NULL,
[JOURNAL_LINE] [int] NOT NULL,
[MOVEMENT_FLAG] [char](1) NOT NULL,
[GL_DISTRIB_STATUS] [char](1) NOT NULL,
[PROCESS_INSTANCE] [decimal](10, 0) NOT NULL,
[ERROR_FLAG] [char](1) NOT NULL,
[FINAL_REF_IND] [char](1) NOT NULL,
[REFERENCE_NUMBER] [char](10) NOT NULL,
[REF_CLOSED] [char](1) NOT NULL,
[REF_DIST_LINE] [int] NOT NULL,
[REF_LINE_NUMBER] [int] NOT NULL,
[BUSINESS_UNIT_PO] [char](5) NOT NULL,
[PO_ID] [char](10) NOT NULL,
[LINE_NBR] [int] NOT NULL,
[SCHED_NBR] [smallint] NOT NULL,
[PO_DIST_LINE_NUM] [int] NOT NULL,
[BCM_LINE_STATUS] [char](2) NOT NULL,
[BCM_POST_AMOUNT] [decimal](26, 3) NOT NULL,
[BCM_POST_AMT_TOT] [decimal](26, 3) NOT NULL,
[BUSINESS_UNIT_PC] [char](5) NOT NULL,
[ACTIVITY_ID] [char](15) NOT NULL,
[ANALYSIS_TYPE] [char](3) NOT NULL,
[RESOURCE_TYPE] [char](5) NOT NULL,
[RESOURCE_CATEGORY] [char](5) NOT NULL,
[RESOURCE_SUB_CAT] [char](5) NOT NULL,
[PC_DISTRIB_STATUS] [char](1) NOT NULL,
[CURRENCY_CD] [char](3) NOT NULL,
[ASSET_FLG] [char](1) NOT NULL,
[BUSINESS_UNIT_AM] [char](5) NOT NULL,
[ASSET_ID] [char](12) NOT NULL,
[PROFILE_ID] [char](10) NOT NULL,
[COST_TYPE] [char](1) NOT NULL,
[AM_DISTRIB_STATUS] [char](1) NOT NULL,
[VAT_DISTRIB_STATUS] [char](1) NOT NULL,
[BUSINESS_UNIT_RECV] [char](5) NOT NULL,
[RECEIVER_ID] [char](10) NOT NULL,
[RECV_LN_NBR] [int] NOT NULL,
[RECV_SHIP_SEQ_NBR] [smallint] NOT NULL,
[RECV_DIST_LINE_NUM] [int] NOT NULL,
[LEDGER_GROUP] [char](10) NOT NULL,
[VAT_TXN_TYPE_CD] [char](4) NOT NULL,
[FREIGHT_AMT] [decimal](26, 3) NOT NULL,
[SALETX_AMT] [decimal](26, 3) NOT NULL,
[USETAX_AMT] [decimal](26, 3) NOT NULL,
[VAT_INV_AMT] [decimal](26, 3) NOT NULL,
[VAT_NONINV_AMT] [decimal](26, 3) NOT NULL,
[DSCNT_AMT] [decimal](26, 3) NOT NULL,
[VAT_RECOVERY_PCT] [decimal](5, 2) NOT NULL,
[VAT_BASIS_AMT] [decimal](26, 3) NOT NULL,
[VAT_BASIS_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_CALC_AMT] [decimal](26, 3) NOT NULL,
[VAT_CALC_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_RCVRY_AMT] [decimal](26, 3) NOT NULL,
[VAT_DSCNT_ADJ] [decimal](26, 3) NOT NULL,
[VAT_DSCNT_ADJ_BSE] [decimal](26, 3) NOT NULL,
[VAT_DSCNT_RCVRY] [decimal](26, 3) NOT NULL,
[VAT_DSCNT_RCVR_BSE] [decimal](26, 3) NOT NULL,
[TAX_CD_VAT] [char](8) NOT NULL,
[TAX_CD_VAT_PCT] [decimal](7, 4) NOT NULL,
[VAT_DCLRTN_DT] [dbo].[PSDATE] NULL,
[OPERATING_UNIT] [char](8) NOT NULL,
[PRODUCT] [char](6) NOT NULL,
[FUND_CODE] [char](5) NOT NULL,
[CLASS_FLD] [char](5) NOT NULL,
[PROGRAM_CODE] [char](5) NOT NULL,
[BUDGET_REF] [char](8) NOT NULL,
[AFFILIATE] [char](5) NOT NULL,
[AFFILIATE_INTRA1] [char](10) NOT NULL,
[AFFILIATE_INTRA2] [char](10) NOT NULL,
[CHARTFIELD1] [char](10) NOT NULL,
[CHARTFIELD2] [char](10) NOT NULL,
[CHARTFIELD3] [char](10) NOT NULL,
[PROJECT_ID] [char](15) NOT NULL,
[VAT_APPLICABILITY] [char](1) NOT NULL,
[VAT_REBATE_PCT] [decimal](5, 2) NOT NULL,
[VAT_REBATE_AMT] [decimal](26, 3) NOT NULL,
[VAT_REBATE_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_USE_ID] [char](6) NOT NULL,
[VAT_ENTITY] [char](20) NOT NULL,
[SHIPTO_ID] [char](10) NOT NULL,
[SUT_BASE_ID] [char](10) NOT NULL,
[TAX_CD_SUT] [char](8) NOT NULL,
[TAX_CD_SUT_PCT] [decimal](5, 2) NOT NULL,
[SUT_APPLICABILITY] [char](1) NOT NULL,
[DOC_TYPE] [char](8) NOT NULL,
[DOC_SEQ_DATE] [dbo].[PSDATE] NULL,
[DOC_SEQ_NBR] [char](12) NOT NULL,
[DOC_SEQ_STATUS] [char](1) NOT NULL,
[POSTING_DATE] [dbo].[PSDATE] NULL,
[IST_DISTRIB_STATUS] [char](1) NOT NULL,
[PRIMARY_LEDGER] [char](1) NOT NULL,
[BUDGET_HDR_STATUS] [char](1) NOT NULL,
[BUDGET_LINE_STATUS] [char](1) NOT NULL,
[CLOSE_STATUS] [char](1) NOT NULL,
[BUDGET_DT] [dbo].[PSDATE] NULL,
[KK_TRAN_OVER_FLAG] [char](1) NOT NULL,
[KK_TRAN_OVER_OPRID] [char](30) NOT NULL,
[KK_TRAN_OVER_DTTM] [dbo].[PSDATETIME] NULL,
[VAT_TRANS_AMT] [decimal](26, 3) NOT NULL,
[VAT_TRANS_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_TRANS_AMT_RPTG] [decimal](26, 3) NOT NULL,
[CURRENCY_RPTG] [char](3) NOT NULL,
[VAT_INV_AMT_RPTG] [decimal](26, 3) NOT NULL,
[IU_ANCHOR_FLG] [char](1) NOT NULL,
[IU_SYS_TRAN_CD] [char](8) NOT NULL,
[IU_TRAN_CD] [char](8) NOT NULL,
[ENTRY_EVENT] [char](10) NOT NULL,
[EE_PROC_STATUS] [char](1) NOT NULL,
[VAT_LN_ENT_AMT] [decimal](26, 3) NOT NULL,
[VAT_LN_ENT_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_MBASIS_AMT] [decimal](26, 3) NOT NULL,
[VAT_MBASIS_AMT_BSE] [decimal](26, 3) NOT NULL,
[VAT_MTRANS_AMT] [decimal](26, 3) NOT NULL,
[VAT_MTRANS_AMT_BSE] [decimal](26, 3) NOT NULL
) ON [PRIMARY]

SET ANSI_PADDING OFF
GO

Destination Table in next Reply as it wouldn't fit here...

Note I could bcp out/in this table without the query attached selecting 100,000 fine. Appreciate your time and suggestions.

Free Windows Admin Tool Kit Click here and download it now

April 19th, 2015 3:01am

Destination Table:

USE [Test_BCP]
GO

/****** Object: Table [dbo].[PS_VOUCHER] Script Date: 04/18/2015 23:44:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

SET ANSI_PADDING OFF
GO

April 19th, 2015 3:06am

Whats the exact error message you got now?

Free Windows Admin Tool Kit Click here and download it now

April 19th, 2015 3:23am

This topic is archived. No further replies will be accepted.