Execute sql task

Question

Post reply

Execute sql task

keywestfl9

SSCertifiable

Points: 5215
More actions
December 3, 2010 at 2:28 pm

#241980

i am trying to create a table in teradata using execute sql task (ado .net) and directinput
but i am getting the following error
Error: The Execute method on the task returned error code 0x80131509 (This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.). The Execute method must succeed, and indicate the result using an "out" parameter.
Can anyone help me on this?

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply

COZYROC One Orange Chip Points: 28499 More actions · Answer 1

This looks like a bug in the driver. Try using OLEDB or ODBC driver instead.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 2

when i use odbc i get error in the query

create table abc(select id from table1) ;

i get syntax error between select and ;

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

keywestfl9 (1/25/2011)
when i use odbc i get error in the query
create table abc(select id from table1) ;
i get syntax error between select and ;

I'm not very familiar with Teradata, but are you sure this is a valid SQL statement? Have you tried executing the statement outside under Teradata bench or another application?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 4

sorry correction in my sql

create table abc as (select id from table1 inner join table2 on table.ano = table2.ano) with data

primary index (id)

;

it works in Teradata sql assistant using odbc driver but not from execute sql task

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

keywestfl9 (1/25/2011)
sorry correction in my sql
create table abc as (select id from table1 inner join table2 on table.ano = table2.ano) with data
primary index (id)
;
it works in Teradata sql assistant using odbc driver but not from execute sql task

When do you get this error? When you press 'Parse Query' command in the task or when you try to execute the task ?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 6

keywestfl9

SSCertifiable

Points: 5215

January 25, 2011 at 1:13 pm

#1278146

when execute

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

keywestfl9 (1/25/2011)
when execute

Hmm, it looks like there is limitation in the Teradata's drivers. You may try using third-party drivers like Attunity.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 8

if i have to use attunity what type of connection is it? Like oledb, odbc

COZYROC One Orange Chip Points: 28499 More actions · Answer 9

keywestfl9 (1/25/2011)
if i have to use attunity what type of connection is it? Like oledb, odbc

Check here.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 10

i won't be able to use attunity in all environment and i was trying to do more research on .net driver

i see this difference when i parse the query in the developer edition i have in system i get

TITLE: SQL Task

------------------------------

Object reference not set to an instance of an object.

------------------------------

BUTTONS:

OK

------------------------------

but if do the same execute sql task in another machine with enterprise edition but no ssis running i get it running

any thoughts on this?

COZYROC One Orange Chip Points: 28499 More actions · Answer 11

Compare the installed versions. Perhaps this might be an issue fixed with SP.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 12

i see select statement works with .net data driver for teradata but not the create table from execute task

when i try odbc i get

[NCR][ODBC Teradata Driver][Teradata Database] Syntax error: expected something between the 'select' keyword and ';'. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

when i parse the query it works but when i execute i get this error

any help on this?

COZYROC One Orange Chip Points: 28499 More actions · Answer 13

keywestfl9 (1/26/2011)
i see select statement works with .net data driver for teradata but not the create table from execute task
when i try odbc i get
[NCR][ODBC Teradata Driver][Teradata Database] Syntax error: expected something between the 'select' keyword and ';'. ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
when i parse the query it works but when i execute i get this error
any help on this?

You said you have machine working properly. Did you compare the versions of SSIS on both machines - working and not working ?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

keywestfl9 SSCertifiable Points: 5215 More actions · Answer 14

the machine which is working is not having ssis running only BIDS installed and enterprise edition

other machine is developer edition and ssis running - this is where it doesn't work.