I do this quite often. You must have the Teradata driver on the server your running on, or the PC your running on. I just use the sql I would normally use for TERADATA and in the data flow use Datasource Reader. Then write my results to an SQL Server table.