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.
| Author |
Topic |
|
ease2002
Starting Member
8 Posts |
 Posted - 2008-06-19 : 10:23:02
|
Hi,I am trying to query Teradata tables from SQL Server 2005 using SSIS that will populate a table in SS 2005. I have been able to test the connection successfully. I choose the Query option b.c the tables in Teradata are over 100 million records and I don't want to copy those tables locally.I am able to enter my query and parse it. I can even preview the query and see the results. A very simple query:select distinct acc_yrfrom d4574fdp.clm_dim But when I try and execute the query, I get the following error message:quote:
TITLE: SQL Server Import and Export Wizard------------------------------Could not connect source component.Error 0xc0202009: Source - Query [1]: An OLE DB error has occurred. Error code: 0x80040E21.An OLE DB record is available. Source: "OLE DB Provider for Teradata" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".------------------------------ADDITIONAL INFORMATION:Exception from HRESULT: 0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap)------------------------------BUTTONS:OK------------------------------
I have the latest OLE DB Provider for Teradata installed. Is there some security setting that needs to be set? Any help would be greatly appreciated.Thank You. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
ease2002
Starting Member
8 Posts |
Posted - 2008-06-19 : 11:14:53
|
| Hi,I changed the field "string" and made it 10 characters when the SSIS wizard allows me to edit mappings. Every character is only 2 characters in the query I posted above. Maybe I am doing something wrong when I attempt to "Edit Mappings".Any further assistance would be appreciated.Thank You. |
 |
|
|
|
|
|
OLE DB Provider for Teradata