Pulling count of records from Teradata

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Pulling count of records from Teradata

13 posts, Page 1 of 2

1 2 »»

Pulling count of records from Teradata

Rate Topic

Display Mode

Topic Options

Author

Message

Prassad Dabbada V R

Posted Tuesday, December 18, 2012 3:38 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 2:36 AM
Points: 222, Visits: 101

Hi,

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 appreciated
IS 2008 and ODBC Drivers for Teradata

Thanks
Prasad

Post #1397659

Jason-299789

Posted Tuesday, December 18, 2012 4:29 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:35 AM
Points: 803, Visits: 2,122

What Data type is the SSIS variable TeraDatacount, and how many rows are you pulling through.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1397689

Prassad Dabbada V R

Posted Tuesday, December 18, 2012 4:37 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 2:36 AM
Points: 222, Visits: 101

Datatype is Int

I am assigning value of below query to the variable

select count(1) from Mytable

Post #1397692

Jason-299789

Posted Tuesday, December 18, 2012 4:51 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:35 AM
Points: 803, Visits: 2,122

what 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.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1397697

Prassad Dabbada V R

Posted Tuesday, December 18, 2012 6:09 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 2:36 AM
Points: 222, Visits: 101

I have changed the datatype of the variable to Int64, still it is giving same error message

The actual count is 38044708, ans Int data type can handle this count.

declare @i int
set @i = 38044708
print @i

Post #1397740

Jason-299789

Posted Tuesday, December 18, 2012 6:25 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:35 AM
Points: 803, Visits: 2,122

Sorry 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 myTable

After that you have the SQL task set to use the result set and pass the value back to an SSIS variable

is that correct?

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1397750

Prassad Dabbada V R

Posted Tuesday, December 18, 2012 6:38 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 2:36 AM
Points: 222, Visits: 101

Yes correct

Post #1397761

Jason-299789

Posted Tuesday, December 18, 2012 6:59 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:35 AM
Points: 803, Visits: 2,122

I'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.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1397773

Prassad Dabbada V R

Posted Tuesday, December 18, 2012 7:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 2:36 AM
Points: 222, Visits: 101

This is working fine when the source connection is SQL Server or Oracle.
When I change the datasource to Teradata it is throwing this error.

Post #1397800

Jason-299789

Posted Tuesday, December 18, 2012 7:45 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 03, 2013 5:35 AM
Points: 803, Visits: 2,122

I'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.

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1397802

« Prev Topic | Next Topic »

13 posts, Page 1 of 2

1 2 »»

Permissions