Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SSIS package failing from autosys

SSIS package failing from autosys

SSIS package failing from autosys

Currently we have a package that takes source as excel sheet and loads data into ole db destination.This package has various transformations like derived column,data conversion,sort,merge,pivot,lookup,multicast etc.We run this package through Autosys job.The issue we are facing is When we are running the job with a xls version the job is running fine but when we convert this to xlsx this is faililng without any error message at a specific task which is inside a for each loop container (very surprising).
Few of the packages were giving such problem and they were terminating abruptly and we changed the delay validation to true and they ran fine from autosys. But with this package i cant figure out what is the issue because with xlsx format this package runs fine from local visual studio but while running from Autosys it exits abruptly at a specific task and the log file seems to incomplete and there is no information about error .While running from local it is not giving any error message and just few warnings like convert the lookup cache mode.I tried many approaches like changing the delay validation to true,increasing the buffer size,changing the lookup cache mode,addng a breakpoint to that specific task.our client wants a consistent version of excel so we are going for xlsx format. One more thing i noticed whenever there is no data for a cell xlsx sends this as blank unlike xls which converts them to null , however adding a derived column to convert the blank cells to null didnot work.
Appreciate any help on this !

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close