October 19, 2008 at 2:58 pm
I'm trying to pass the results of a simple select statement into the where clause in an OLE DB Source.
I have an execute SQL task setup which passed the data to a variable as such:
Query: select email from tableA
ResultSet = Full Result Set
Result Set: Result Name = 0, Variable Name = User::list
Variable is setup like so:
Name = list
Scope = Package
Data Type = Object
In my OLE DB Source, I am using a SQL Command that looks similar to this:
SELECT colA, colB, colC
WHERE name IN (?)
GROUP BY colA, colB
My parameter is mapped as such: Parameters = 0, Variable = User::list
My simple select statement is one column with multiple 30 or more rows of data. The problem is that this data is not getting passed to the OLE DB Source, because I am not getting any records pulled back and I get this error:
"Invalid character value for cast specification".
What am I doing wrong?
_______________________________
[font="Tahoma"]Jody Claggett
SQL Server Reporting Analyst[/font][/size]
October 20, 2008 at 6:45 am
Hello
please try select cast(email as varchar(255)) from ....
What type has the variable ? String ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply