Extract Data from Teradata using SSIS

UDA

Extract Data from Teradata using SSIS

Hi,

I am a SSIS ETL guy and i need to extract data from Terada database, it is an new project recently i got assigned.

Please give me some check list how can connect teradata and what are steps i should follow before going to develop SSIS Packages.

Thanks....
2 REPLIES
Fan

Re: Extract Data from Teradata using SSIS

You will probably need to install the Teradata ODBC or OLE DB driver onto the SQL Server so that SSIS can create a connection to Teradata. Of course you will need a user account as well.

Re: Extract Data from Teradata using SSIS

hello

i am facing some problems in ssis.

1) [ODBC teradata driver] query timeout expired.

-> background

data i am fetching is around 250 rows and 5 columns. while previewing the data it send the error writen above.

2) is TPT API is necessary if i want to get data directly from teradata source using attunity teradata connector?

regards

Majid Baig.