I checked all the variables value and it comes correct and without variable it works fine.

Not sure what is causing this

yes that is what i want to do. i am accessing Teradata and the pwd expire every 90 days so i got to go thru few steps to get the...

i am getting this error on my execute sql task and i was told in this forum to try different driver but unfortunately dba can't do oledb or odbc .

execute...

i am using package configuration thru dtsconfig file.

i created a system ODBC connection thru Control Panel - admin tools and used that odbc for ssis connection manager with id and pwd

i created a execute sql task to...

can you also tell me if i can do the same using script task if so how i do get the reference of teradata driver

i am using same driver (.net) but different edition in machines.

thru Bids

i have just installed tools (BIDS) and not integration service

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.

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

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

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

when execute

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