Mike,

The driver is sampling the first n number of rows to determine what would be appropriate type for the column. As you understand the Excel is not true database and...

Compare the versions of the installed editions.

If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It is an extension of the standard Data Flow Task and it was created to solve...

What happens when you use IMEX=1 ?

Hi,

Yes, you can do this . You have to setup SSIS expression, which modifies the SMTP connection manager properties. Here is how to do it:

1. Right-click on the SMTP connection...

You have to use the standard 'Derived Column' transformation to transform the source columns into the appropriate destination column types.

Check this article by Matt Masson.

You cannot execute SSIS packages if you don't have the SSIS framework installed. So again I would recommend you compare the versions on both machines and also check...

Then how do you execute SSIS packages on this machine if you don't have integration service installed?

keywestfl9 (1/26/2011)

---

the machine which is working is not having ssis running only BIDS installed and enterprise edition

other machine is developer edition and ssis running - this is where it doesn't...

keywestfl9 (1/26/2011)

---

i see select statement works with .net data driver for teradata but not the create table from execute task

when i try odbc i get

[NCR][ODBC Teradata Driver][Teradata Database] Syntax error:...

Compare the installed versions. Perhaps this might be an issue fixed with SP.

Check here.

Hmm, it looks like there is limitation in the Teradata's drivers. You may try using third-party drivers like Attunity.

keywestfl9 (1/25/2011)

---

sorry correction in my sql

create table abc as (select id from table1 inner join table2 on table.ano = table2.ano) with data

primary index (id)

;

it works in Teradata sql assistant...