Excel Destination

Data types. The Excel driver recognizes only a limited set of data types. For example, all numeric columns are interpreted as doubles (DT_R8), and all string columns (other than memo columns) are interpreted as 255-character Unicode strings (DT_WSTR). Integration Services maps the Excel data types as follows:
  • Numeric double-precision float (DT_R8)
  • Currency currency (DT_CY)
  • Boolean Boolean (DT_BOOL)
  • Date/time datetime (DT_DATE)
  • String Unicode string, length 255 (DT_WSTR)
  • Memo Unicode text stream (DT_NTEXT)

留言

張貼留言

這個網誌中的熱門文章

使用VB讀取健保卡基本資料

Imports System Imports System.Text Imports System.Runtime.InteropServices Class CitizenDigitalCertificateCardNoReader Public Structure SCARD_IO_REQUEST Public dwProtocol As Integer Public cbPciLength As Integer End Structure '引用 PC/SC(Personal Computer/Smart Card) API WinScard.dll _ Public Shared Function SCardEstablishContext(ByVal dwScope As UInteger, ByVal nNotUsed1 As Integer, ByVal nNotUsed2 As Integer, ByRef phContext As Integer) As Integer End Function _ Public Shared Function SCardReleaseContext(ByVal phContext As Integer) As Integer End Function _ Public Shared Function SCardConnect(ByVal hContext As Integer, ByVal cReaderName As String, ByVal dwShareMode As UInteger, ByVal dwPrefProtocol As UInteger, ByRef phCard As Integer, ByRef ActiveProtocol As Integer) As Integer End Function _ Public Shared Function SCardDisconnect(ByVal hC...
閱讀完整內容

北港壽豐奇遇記

真是難得北港媽東巡到壽豐媽住駕，當我在接到北港的金身感覺無比興奮好像中樂透一樣，他的木頭一定用很好的材料二尺二的金身真的很重，對了還有他彫功很利害臉看起來很飽滿就好像很久不見的阿媽😭，期待在相見。  
閱讀完整內容