Thanks Ken. Unfortunately, I don't know of a way to connect directly to Teradata from SQL Server 2005 to write code. I think it works in SQL Server 2008 but not in 2005 unless I am mixed up about that which is entirely possible. I know that I can link from Visual Studio but not from Management Studio.