Table "AP"."AP_CREDIT_CARD_TRXNS_ALL":
0 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

i did the above change and run again i got the following error. also i wanted to note that i opened TAR for the same and they says that the value return from data file for 46:53 will be 0000612 and not 20000612 b'caz when you specify 46 it will start from 47.. i don't think so this is true.

Thanks fox for your suggession.. but i solved the problems. The positioning is wrong in data file. and when u specify 46 it starts from 47 so in order to capture value of position 46 one need to specify 45. that is what Oracle people suggested.

Featured Post

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Configuring and using Oracle Database Gateway for ODBC
Introduction
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…

How to Unravel a Tricky Query
Introduction
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …

This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.