Teradata SQL Assistant Import

Database
Enthusiast

Teradata SQL Assistant Import

Hi All -

Can you please help me findin a solution for below issue.

I am trying to import txt file data into teradta table using import option and iam getting below error

 Error importing record 0:  [100056] Total size of parameters is greater than the max Data parcel size.

Only 0 rows were loaded. 

Can some please help me to overcome this error to lod the data into tabel.

I am using ODBC connection

Thank you

2 REPLIES
Enthusiast

Re: Teradata SQL Assistant Import

Usually, this error comes up when the size of SQL issued to Teradata is greater than the allowed length (1 MB).

Can you check if the generated SQL is large enough to cause this error? If yes, you can breakup sql and create its view to avoid this error.

Cheers,

BM

Enthusiast

Re: Teradata SQL Assistant Import

Thank you for looking into this however i tried to run the same using bteq import and it worked .