Hello,

I am receiving the errors below when I try to execute a dynamic SSIS package using Teradata source and destination objects.

{6C67E2EA-A266-4535-8603-4D030BB0401C};Teradata Destination [24];TPT attribute value is out of range. Trace Level: 111895948
{6C67E2EA-A266-4535-8603-4D030BB0401C};SSIS.Pipeline;Teradata Destination failed the pre-execute phase and returned error code 0x80004005.


Below are my settings for the Teradata Destination Component. Am I missing anything or what could be out of range:?

//Set the destination properties
instanceDestination.SetComponentProperty("AlwaysDr opErrorTable", false);
instanceDestination.SetComponentProperty("ArraySup port", true);
instanceDestination.SetComponentProperty("BlockSiz e", 64330);
instanceDestination.SetComponentProperty("Buffers" , 3);
instanceDestination.SetComponentProperty("BufferSi ze", 64);
instanceDestination.SetComponentProperty("DataEncr yption", false);
instanceDestination.SetComponentProperty("DefaultC odePage", 1252);
instanceDestination.SetComponentProperty("Detailed TracingLevel", "Off");
instanceDestination.SetComponentProperty("Detailed TracingFile", "c:\temp\tptdestinationlog.txt");
//instanceDestination.SetComponentProperty("ErrorTab leName", "");
// instanceDestination.SetComponentProperty("Extended StringColumnsAllocation", false);
//instanceDestination.SetComponentProperty("QueryBan dSessionInfo", "");
//instanceDestination.SetComponentProperty("Replicat ionOverride", 0);
instanceDestination.SetComponentProperty("FastLoad ", true);
instanceDestination.SetComponentProperty("MaxError s", 0);
instanceDestination.SetComponentProperty("MaxSessi ons", 1);
instanceDestination.SetComponentProperty("MinSessi ons", 1);
instanceDestination.SetComponentProperty("Robust", true);
instanceDestination.SetComponentProperty("TableNam e", "mydatabase.mytable");
instanceDestination.SetComponentProperty("ErrorTab leName", "none");

Any help is greatly appreciated.

Thanks,
Rick B.