Converting SSIS Data Types to .Net Data Types

Integration Services 2005 / SSIS (DTS)

If you use Scripting tasks, the CLR or build components for SSIS, you will need to convert values from their SSIS types into .Net types. Here's a quick list of  the SSIS data types and their .Net companion.

Integration Services
Data Types
Managed
Data Type
DT_WSTR
DT_TEXT
DT_STR
 
System.String
 
DT_BYTES
DT_IMAGE
 
System.Byte[]
 
DT_DBTIMESTAMP
DT_DATE
 
System.DateTime
 
DT_NUMERIC
DT_DECIMAL
 
System.Decimal
 
DT_I1
 
System.Byte
 
DT_I2
 
System.Int16
 
DT_I4
 
System.Int32
 
DT_I8
 
System.Int64
 
DT_BOOL
 
System.Boolean
 
DT_R4 
 
System.Single
 
DT_R8 
 
System.Double
 
DT_UI1
 
System.Byte
 
DT_UI2
 
System.UInt16
 
DT_UI4
 
System.UInt32
 
DT_UI8
 
System.UInt64
 
DT_GUID System.Guid

Books Online also lists these conversions.



Share
  • Facebook
  • Google Bookmarks
  • Ask
  • LinkedIn
  • Socialogs
  • Wikio
  • Digg
  • Twitter
  • SlashDot
  • Reddit
  • MySpace
  • Del.icio.us
  • Blogter
  • BlogMemes
  • Yahoo Buzz






Converting SSIS Data Types to .Net Data Types | 1 comments | Create New Account
The following comments are owned by whomever posted them. This site is not responsible for what they say.
Extract data from ACCESS database with pwd via ODBC
Authored by: Anonymous on Tuesday, May 15 2007 @ 06:17 PM AEST

Hi,

My task is simple, I want to use the execute sql task editor to grab a
value from a database in Access and put it in a variable. The
connection is via ODBC and the access database is protected by a
password.

I've done all the preliminary stuff such as running profiler to make
sure that the package is getting the call to the database, setting up
the ResultSet to be "single row" in the general tab, mapped the Result
Set correctly, but nothing works. I get the same error every time.

This is my sql command:

select count(FingerPrintID) as FingerPrint

from Employee

Result Set is set up like this:

Result Name: FingerPrint ; Variable Name: User:: varDataset

Here is the error I get:

Error: 0xC002F309 at Execute SQL Task, Execute SQL Task: An error
occurred while assigning a value to variable "varDataset": "Value does
not fall within the expected range.".

My variable is set up as a Int16.

Please help!!!!!

If you could provide step by step example's that would really make my
day.

Thanks,

Lawrence

[ # ]


Gold Coast Aquarium Maintenance | Gold Coast Marine Fish | Gold Coast Tropical Fish
Jewel Jones - Counselling Service - Penrith, Richmond
 
     
 Copyright © 2017 Julian Kuiters
 All trademarks and copyrights on this page are owned by their respective owners.