|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/15/2009 3:08:08 AM
Posts: 3,
Visits: 43
|
|
Hi,
I try to load a Teradata table in Microsoft SQL Server 2008 Integration Services using OLE DB command transformation, but I have problems passing the column parameters of the Teradata table to the transformation.
In the OLE DB command transformation I use the following SQL command:
update p.resource set validTo=? where Id=?;
Because the system does not automatically recognize the parameters I entered the following external columns manually:
- Param_0:
DBParamInfoFlags=1
Datatype=DT_DBTIMESTAMP
- Param_1:
DBParamInfoFlags=1
Datatype=DT_STR
CodePage=1252
Length=36
The data types of the source columns are equal with the parameter data types above.
I also manually set the column mappings, but I get the following error message:
Unable to retrieve destination column descriptions from the parameters of the SQL command.
I tried a lot but I am not able to solve this problem. But I found out, that this problem only occurs when one of the parameters is a string (DT_STR). If I use a numeric parameter instead, everything works fine.
Unfortunately I have to use string parameters in certain situations, so avoiding strings is not a solution...
Is there maybe a better way to update Teradata tables in SSIS 2008?
Does anybody have experience updating Teradata tables in SSIS 2008 in general or with the OLE DB command in special?
Thanks in advance!
Best regards,
Helmut
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 1/22/2010 7:13:21 PM
Posts: 155,
Visits: 459
|
|
Yes there is a better way; in this blog
[url=http://developer.teradata.com/blog/netfx/2009/06/little-known-secret-about-microsoft-bi-tools-and-teradata][/url]
there is a link to "Microsoft Connectors for Teradata by Attunity". You can download it (free) from Microsoft but it requires Teradata TPT-API.
Also you can use ".NET Data Provider for Teradata" instead of "OLE DB".
.NET Data Provider for Teradata supports Batch Update and it works well with SSIS2008 as Data Source or Target.
--Cal
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/16/2009 6:55:04 PM
Posts: 3,
Visits: 4
|
|
The SSIS connector seems to work great, but I'm getting an error when I try to run the package : "[Teradata Source [1]] Error: The Teradata TPT registry key cannot be opened. Verify that the TPT API 12.0 for Windows x64 is installed properly."
I have only been able to find a 32-bit version of the TPT API, but running a 64-bit OS, DBMS, Teradata drivers, etc. I'd like to continue with 64-bit across the board. The Teradata Corporation Front Desk sent me an email stating the 64-bit TPT API 12.0 does not exist. Is this possible? Do I need to remove the 64-bit drivers and replace them with 32-bit to get this to work?
|
|
|
|