InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 14:59:06 GMT20http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxThat worked perfectly Thanks JasonWed, 19 Dec 2012 01:52:35 GMTPrassad Dabbada V Rhttp://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxThanks Jason,This could be good solution, I will work on this.Thanks for your solution.Tue, 18 Dec 2012 08:58:48 GMTPrassad Dabbada V Rhttp://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxPS : just had one thought of inspiration [url]http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1a91b594-23b0-47f5-940b-4ee067f82fe2[/url]Its using a different driver, but could still be a valid solution.Tue, 18 Dec 2012 07:47:27 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxI'm going to have to bow out as I have limited knowledge of Teradata.It sounds very much like an ODBC/Teradata driver error, have you tried the TeraData forums to see if anyone has seen this issue before with SSIS.Tue, 18 Dec 2012 07:45:10 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxThis is working fine when the source connection is SQL Server or Oracle.When I change the datasource to Teradata it is throwing this error.Tue, 18 Dec 2012 07:40:36 GMTPrassad Dabbada V Rhttp://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxI've just tested this and it shuold work with an INT32 datatype.How is your tast set up? is it set to use Single or Full row count?The Variable is set up in the Result set part of the SSIS SQL task, with the Result name set to 0 and Variable name pointing at the correct variable.Tue, 18 Dec 2012 06:59:02 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxYes correctTue, 18 Dec 2012 06:38:44 GMTPrassad Dabbada V Rhttp://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxSorry I thought the variable you were using was in the SSIS package not an SQL variable.I take it the SQL Task you have just does SELECT COUNT(1) From myTableAfter that you have the SQL task set to use the result set and pass the value back to an SSIS variableis that correct?Tue, 18 Dec 2012 06:25:23 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxI have changed the datatype of the variable to Int64, still it is giving same error messageThe actual count is 38044708, ans Int data type can handle this count.declare @i intset @i = 38044708print @iTue, 18 Dec 2012 06:09:29 GMTPrassad Dabbada V Rhttp://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxwhat scale is the int in SSIS, there are 5 maintypes INT16, INT32 and INT64 plus the Unsighed versions (UINT32 and UNIT64)An Int16 can only hold numbers upto +/- 32767, an INT32 can hold numbers upto +/-2^15.I would look to use the Int32 datatype in SSIS for this kind of thing unless you can guarantee that the row count will be less than 32000 rows of data.Tue, 18 Dec 2012 04:51:54 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxDatatype is IntI am assigning value of below query to the variableselect count(1) from MytableTue, 18 Dec 2012 04:37:07 GMTPrassad Dabbada V Rhttp://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxWhat Data type is the SSIS variable TeraDatacount, and how many rows are you pulling through.Tue, 18 Dec 2012 04:29:14 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1397659-391-1.aspxHi,I am pulling count of records from a Teradata table.I have used Execute SQL Task in SSIS to get the count, based on the count I want to proceed further.while I am execuing the package I am getting below error[Execute SQL Task] Error: An error occurred while assigning a value to variable "TeradataCount": "Value does not fall within the expected range.".Note: I am using SSyou help is much appreciatedIS 2008 and ODBC Drivers for TeradataThanksPrasadTue, 18 Dec 2012 03:38:18 GMTPrassad Dabbada V R