Hi,

How are you building your package?  Are you selecting the "Other Connection" to connect to Oracle?  You should get an option "User/System DSN". 

thanks very much for your help everybody!

great thanks.

thanks for your help, this worked...

Thanks for the link.....I'll do a bit of reading and see if this helps...

Its a good start!

Hi,

Thanks for that, but I didn't actually want to run it through the SQL Server Agent.  I have some backup jobs and DTS packages that currently run as jobs in...

thanks for your help.....I must have selected the "slow" google search option...

thanks again..

There's no pleasing everybody....

I enjoyed the article...whether I agree or disagree doesn't really matter.  Everyone has their own opinion.

It was fun to read.  Thanks Sean.

thanks.

So I guess the only way around this problem would be to create two DTS packages that have different SELECT ranges?  Would anyone agree?

Hi,

The query runs fine, if I reduce the number of rows to be copied, the job completes successfully. If I increase the number of rows, the job fails with "out...

Hi,

The query is fine, it does transform a number of rows, but then I guess it runs out of memory and fails...

Hi,

I am using a query to tranform the data.

Hi,

I have found my problem....I didn't have my transformations defined correctly...doh!.

yep here it is:

select [MemberNo],

''+substring(convert(varchar(30), EffDate, 120),9,2)

+'.'+substring(convert(varchar(30), EffDate, 120),6,2)

+'.'+substring(convert(varchar(30), EffDate, 120),1,4)

+'' AS [EffDate],[Action],[PersonID],[HomeAddrID],[PostalAddrID],

case when EndDate is not null then

''+substring(convert(varchar(30), EndDate, 120),9,2)

+'.'+substring(convert(varchar(30), EndDate, 120),6,2)

+'.'+substring(convert(varchar(30), EndDate, 120),1,4)

+'' else '01.01.0001' end...

thanks very much!