Home Forums Data Warehousing Integration Services SSIS Package executes successfully in dev/test environment but fails in production RE: SSIS Package executes successfully in dev/test environment but fails in production

  • Get your DBA to look at the filenames in the production pathing. Most likely one of them has an invalid naming convention that you're picking up and trying to convert. You won't be able to directly troubleshoot this without access to the job logs and the data informing the package, you're going to need support from above.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA