0 - 12 of 12 tags for sql server

Hello,
I need to execute a Teradata stored procedure in SQL Server.
I tried so far the following:
1) exec ('call CIONESCU.stp_agg_3 ();') at [Teradata_CIONESCU]
2) select 1 from openquery (Teradata_CIONESCU,'call CIONESCU.stp_agg_3 ();')

Hi all,
I am building an SSIS package in SQL Server BIDS 2008 version to pull data from Teradata and dump to SQL Server.
1. I am able to connect to Teradata sucessfully as Source.
2. Connection to SQL Server as Destination is also good.
2. When I am running the package I am getting the error
*********  ERROR *******

Hi,
I am working on a project which is intended to migrate our SQL Server DataBases to TeraData. We are using TD 13.10.
1. I have tried OleLoad. But using this we can only export one table at a time.
2. I have used EFS Tools. But data Conversion is wrong.

Hi everyone.  I'm trying to load SQL server tables to Teradata14 using OleDB via TD's OleLoad tool.  I'm having trouble with attributes defined as VARCHAR(MAX) in SQL server - it seems that this is a LOB data type.  Here is the script that OleLoad is generating:

Hi gurus,
I have an application where i have to download data from Teradata into SQL Server, update data in SQL Server and push it back to Teradata server.
I am able to import data from Teradata into SQL server using SQL Bulk Copy. I am trying to see how to push data to Teradata.

Hello!  I'm new to the forum, nice to meet you all. 

 

Delta Community Credit Union is hiring for a full-time Senior DBA position managing a large Teradata warehouse and a set of SQL Server application servers.  Experience in Business Intelligence preferred.  Great compensation and world-class benefits at a small company within the Delta family.  Come check it out!

 

Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
When I try to do an Update to my table on Teradata - I have nothing that lets me specify the Database or Table I want to update - but I get a response saying everything completed successfully.

I am about to migrate data from SQL Server 2008 to Teradata 13.10.

Does anyone have a:

1) a list of datatype comparisons

2) a list of migration tips and traps

Thanks

Hi,

I'm not sure if I posted this in the right forum, but here goes.

I need to load (basically copy) tables from a SQL Server application and load those tables to Teradata. I can access the tables thru SQL Assistant now, but am not sure how I should set up this "copy" from one platform to another. There are 100+ tables that I need to copy, and this copy will be done on a regular basis (weekly or monthly) so a manual process is not ideal.

Someone suggested using OLE Load to do this copy. Is this the best way? Can OLE Load be set up to run in batch mode? If so, how?

We currently have an opening for a Senior Database Adminsitrator at Delta Community Crit Union in Atlanta, GA. Our ideal candidate will be a versatile, well-rounded person with strong Teradata administration, development, ETL and modeling experience, MS-SQL Server administration experience, as well as varied other technology experience and background.

Microsoft and Teradata worked together last year to integrate SQL Server Reporting, Analysis and Integration Services with Teradata Database. Some MSDN links that provide additional information: