Try to use TO_NUMBER(numeric_column) explicitly in your oracle datasource/lookup query.

Once, i have same numeric problem with openrowset query to oracle.

hope this help 🙂

Yups,

the problem is in the number of logical processor.

So, in order to install sql 2005, the number of logical processor has to be reduced into only 1 logical processor...

Here is the error in Summary.txt :

Machine : ANCHOVY

Product : Microsoft SQL Server...

I like it. It helps me a lot and the more important is i don't third party application

to get it, like i used to be in SSMS 2005.

But, i have...

Already find the solutions...the problem is not in the script component, but somewhere else that is not related to scriptcomponent at all.

The problem is : truncated tables that use the...

Problem solved.

Variable mapping do it function very well :p

Sry for asking in a hurry..

Now, i have to figure out how to generate excel file for each AnimalID.

And, i still...

Dear Bro ALZDBA,

Thanx for your suggestion, but it's not work yet.

The query result would be like this :

PrimaryKey1 PrimaryKey2 TitleOrder Title TitleDescription

1 1 0 Movies A great movies

1 1...

Dear Vijaya,

You should try using Lookup component in data flow task before u do any

insert/update.

Lookup component has 2 path, for error (red) and valid (green).

If it's a new...

Sry, please check Excel Connection Manager.

There is an option "First row has column names". By default, this option already checked. 😀

regards

Yes it works 100% that way, GSquared 🙂

It's my mistake posting this question 😛

Yesterday, i'm obsessed to control user type mismatch for a new record in my table,

even if...

There should be no problem with excel header.

In my experience, I'm just choosing External Column Menu (Column in excel) and the column header never loaded into table in my database.

Maybe...

Thanx Markus,

So I'll just need to install those component of IIS 7,

then installing reporting services is not a problem any more 🙂

Thanks God it's supported..

I'm using linked server to connect. I guess there something wrong in my server setting.

I think there's nothing wrong in sql syntax, just the connection. I've tried...

If Brad login with his ID, well than, that's exactly what i want . There will be no problem with that.

Nope, i defined...

Is it free? 'Cause i'm a poor SQL newbie >.<" :p