ETL and Data Integration tools - Modern ETL software for everyone

Hi

I have a transformation that looks at an Oracle view and appends the information to an Excel table.

It works absolutely fine if I manually run it. All is saved etc.


I want to schedule this as a task, so I create a package with the transformation in it, and only the transformation, and it fails.

Information 19/05/2011 09:04:34 Preparing to execute Seed check
Information 19/05/2011 09:04:34 Package Started
Information 19/05/2011 09:04:34 Executing Transformation: Seed extract
Information 19/05/2011 09:04:34 Source DSN: Data1.telehouse
Information 19/05/2011 09:04:34 Processed: Records
Information 19/05/2011 09:04:34 Errors:
Information 19/05/201 09:04:34 Records per second:
Error 19/05/2011 09:04:34 Execution of Transformation has failed
Error 19/05/201 09:04:34 Package Failed


Not much to go on, but any ideas?

Kind regards,
Andrew

Andrew.

Is your repository MS Access or something else?

John

Hi John

It's the default Access repository.

The reader is set up to ODBC into an Oracle view and the Writer is appending to a Excel 2003 file.

Kind regards,
Andrew

Can you try to compact and repair repository in ms access

John

Andrew.

You need to close the Transformation before runnig the package.

When Transformation is open excel file is locked so you can't write any data into it.

This will be fixed in the next release

Best regards,
John