Converting SSIS Data Types to .Net Data Types

Authored by: lawrence on Tuesday, May 15 2007 @ 05:17 PM EST

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

[ # ]