Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  OLE DB SSIS

Author  Topic  wd7179 Starting Member 10 Posts Posted - 2008-03-04 : 13:42:41 I am having trouble with importing data from a Teradata source. I loaded the OLEdb drivers, went into SSIS and set up the source and destination connections. I am on a 64 BIT Entrprise SQL 2005. I can get the import to work as long as I use the Table/View option, if I try to write the SQL Freehand or use the QUery Builder I get an error "Exception From HResult: OxC0202009 (Microsoft.SqlServer.DTSPipeLineWrap). The Query parses just fine. I have set the Run64BitRuntime to False, to get the import to work when using the Table/View selection. I can't figure out why I am getting an error when everything parses correctly.