Amber's Lab

Data Type

SQL Server (SqlClient)

Oracle (OracleClient)

DT_BOOL

bit

 

DT_BYTES

binary, varbinary, timestamp

raw

DT_CY

smallmoney, money

 

DT_DATE

date

 

DT_DBDATE

date

 

DT_DBTIME

 
 

DT_DBTIMESTAMP

datetime, smalldatetime

timestamp, date, interval

DT_DECIMAL

decimal

 

DT_FILETIME

 
 

DT_GUID

uniqueidentifier

 

DT_I1

 
 

DT_I2

smallint

 

DT_I4

int

 

DT_I8

bigint

 

DT_NUMERIC

decimal, numeric

number, int

DT_R4

real

 

DT_R8

float

float, real

DT_STR

char, varchar

 

DT_UI1

tinyint

 

DT_UI2

 
 

DT_UI4

 
 

DT_UI8

 
 

DT_WSTR

char, varchar, nchar, nvarchar, sql_variant, xml

char, rowid, varchar2, nvarchar2, nchar

DT_IMAGE

image

long raw, blob,loblocator, bfile, vargraphic, long vargraphic, user-defined

DT_NTEXT

text, ntext

long, clob, nclob, nvarchar, text

DT_TEXT

text

 

SSIS錯誤訊息：
[ADO NET 來源 [2348]] 錯誤: System.BadImageFormatException: 不是正確的 Win32 應用程式 。 (發生例外狀況於 HRESULT: 0x800700C1)
於 Microsoft.Data.SAPClient.SAPConnection.Open()
於 Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
於 Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
於 Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
於 Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
解決方式：
於專案上按右鍵→屬性→組態屬性→偵錯→偵錯選項→Run64BitRuntime改為False