I know there are specific SSIS connectors for Teradata, but not sure they are available for 2005.
Never worked with Teradata myself.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP