Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration

TOPIC: Package Error

Package Error 10 months 2 weeks ago #18305

  • LLandRH
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 43
  • Thank you received: 1
Hi there,

I am currently running a package for the first time but it seems to be giving me error. When I run both transformation separately they work fine, however it seems like it's something wrong with the package. Attached is a screenshot of my error log (the first 10 items of the error log doesn't seem like it's relevant to my package I don't know why it is running this way). and my package set up. Can someone please help me identify the problem?

Thanks
Attachments:

Please Log in or Create an account to join the conversation.

Package Error 10 months 2 weeks ago #18307

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7522
  • Karma: 33
  • Thank you received: 409
When the package is executed it creates a package execution log and it also creates transformation execution log.

Habe a look at transformation execution log. It might give you more detailed information about the error

www.etl-tools.com/wiki/aetle/execution_automation/execution_log
Mike

Please Log in or Create an account to join the conversation.

Package Error 10 months 2 weeks ago #18314

  • LLandRH
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 43
  • Thank you received: 1
Hi Mike,

Thanks for the response. Please see attached for my execution log. It says that it could not find file in Access for the transformation ASR. However, when I run the transformation ASR individually it works perfectly fine. Do you know what could've been the reason for this error?

Thanks

Attachments:

Please Log in or Create an account to join the conversation.

Package Error 10 months 2 weeks ago #18317

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7522
  • Karma: 33
  • Thank you received: 409
We have a WIKI article dedicated to this problem (and a video as well)

www.etl-tools.com/wiki/knowledgebase/cou...nd_any_files_to_read
Mike
The following user(s) said Thank You: LLandRH

Please Log in or Create an account to join the conversation.

Package Error 9 months 3 weeks ago #18416

  • LLandRH
  • Topic Author
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 43
  • Thank you received: 1
Hi Mike,

Thanks for the response and the video was helpful. We have successfully ran the package.

However we are still facing a problem - The package ran without any error but all I'm seeing is the last transformation of the package generating an output, while the rest of the package did not. Is there something with my setting that might cause this problem?

Thanks

Please Log in or Create an account to join the conversation.

Package Error 9 months 3 weeks ago #18417

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7522
  • Karma: 33
  • Thank you received: 409
I am very confused here, please post a screenshot
Mike

Please Log in or Create an account to join the conversation.

We have 221 guests and no members online