0 - 7 of 7 tags for ssis

I have a SQLSERVER 2012 database running on a Windows Server 2012 platform.   I have installed the Microsift Connector for Attunity Version 2.0 and in SSIS I now have Teradata Source and Destination tools available.  I have created a connector to the database and table I which to use in my SSIS package.  The connector works and it allows me to preview the

Hi,
I am trying to load a delimited flat file with " as qualifier. We use SSIS 2008 and using  attinuity connector for teradata destination.
The load seems to be running but in the end it fails with the below error and it doesn't commit any records :
 

Hi, I'm a recruiter for a premiere consulting firm
We currently have a job available for a teradata developer (with experience in ETL/SSIS) in florida with one of our direct clients
If you would like to apply please send me your latest resumes at jjones@virtelligence.com
Regards
Jim

Hi, I have had a search through the forums (and google) and have found plenty of discussions about teradata ODBC drivers, but none that seem to quite match the issue I am seeing....
 

I am new to the forum so forgive me if this post seems remedial or incomplete.  We work with data coming from two types of data sources (MS SQL Severs, and Teradata Servers).  For a number of projects, we need to compare information across these two server types.  There are probably a number of ways to accomplish this but we are looking for an approach th

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?

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: