Create ETL Project with Teradata through SSIS

11,960 views 4 comments about 5 years ago Raymond Tang

Re: Create ETL Project with Teradata through SSIS

Ra*** about 3 years ago

@Sasi Kumar

Apologies  for the late reply.

You can pass variables as you can do with any database, I.e. use variable expressions to prepare the statement.

Sas*** about 3 years ago

How to pass user variables in the query.
Add comment

Comments (4)

Raym*** about 4 months ago

I don't have SSIS in my current PC any more. However it should work.

Are there are any objects in your database? And also does your account have access to list the tables or views in the database?

Ar*** about 4 months ago

after the configuration step instead of using SQL command have you tried tables or views in dropdown ? cause i have tried and i'm getting no tables or views could be loaded. 

Ar*** about 4 months ago

after the configuration step instead of using SQL command have you tried tables or views in dropdown ? cause i have tried and i'm getting no tables or views could be loaded. 

Ra*** about 3 years ago

@Sasi Kumar

Apologies  for the late reply.

You can pass variables as you can do with any database, I.e. use variable expressions to prepare the statement.

Sas*** about 3 years ago

How to pass user variables in the query.

Sas*** about 3 years ago

How to pass user variables in the query.