Ssis error with a declare

Question

hai,

My table has 267 rows and the design is varchar. In my table in field varchar are numbers and letters.

Is there a max on the table, because when I have 256 rows the declare is fine, when I have 257 rows I see the next error: My code is: declare @start int  set @start=(select cast(waarde as int) from table where type = startdate " failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Answer 1

How many records in the table have type value of "startdate"?  If there are more than one, then the query should fail.

---

Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008

Answer 2

Hi, limit on number of rows? 256?? No, there's no such limit. Probably the issue is with the data that's on your table. Can you run that statement in management studio? Maybe the issue is related with that cast to int...

David.

Answer 3

are you sure

select cast(waarde as int) from table where type = startdate

part of the query returns only one value.

If not, this will be the possible reason for t he query execution fail.

Thanks,

Hemendra

 

Answer 4

Hai,

No I can't run this statement in de management studio. Same error.

Answer 5

Here is a thought.  Run the query in SSMS without the variable assignment, the on that Hemendra recommended.  If it returns more than one row, then you cannot assign the value to a variable.  Get your query to work in SSMS, then use SSIS.

---

Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008