Anyone know the origin of sql 2005's datatype naming convention or even why SSIS has defined its own special data types (Before SSIS I had never seem types like DT_UI1 except in programming languages.)
TIA,
barker
Newbie: DT_I1, DT_STR, etc
Hot Topic
- Unable to read local eventlog (the parameter is incorrect)
- Applying the updates to SQL Mobile Server?!
- Charts on multiple pages??
- How to use sp_addlogin
- using filters to full text search inside pdf & word documents
- removing duplicate rows
- CellSet.get_Item peformance degradation
- Help on replication from SQL 2005 to DB2/AS400
- Report layout
- Differences between SQL 2005 Editions (Ent vs Std)
SQL Server
- Time Intelligence gives this failure if X64bit installed on a different drive
- Subscription Log Errors
- add subscriber in publication database`
- SQL Server 2005 Express Edition -Configuration Manager
- How to show duplicates in reports
- ActiveX Script transformation column in SSIS but how???
- Is there a way to Un-sum in SQL Server 2000 Reporting Services
- SQL 2005 and SQL 2000, one Dev server, co-existence
- CLR Performance
- SSIS Requests...
Newbie: DT_I1, DT_STR, etc
Melvin S. Bernstein
The reason of having SSIS's own data types is quite obvious, being a ETL tool SSIS pulls data out, as well as sends result to, various systems - It tries to get a best set of types to cover all possible data types that could be encountered during this process.
Actually you can see UI1/UI2/I1/I2/STR...data types in most OLEDB/ADO/ODBC ...programming references.
HTH
wenyang