DataType Validation package

• Gunjan

  Hall of Fame

  Points: 3226

  More actions

  June 20, 2012 at 12:10 pm

  #260193

  I have developed a package which validates the pipe delimited file columns for datatype.

  I have simply used a flat file as a source and in ErrorOutput section I have selected as "Redirect Row" in Error column. It works fine when I execute it from the development environment. But it throws below error when I run it as a Job from the production server:

  Executed as user: sqlagent. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:25:49 PM Error: 2012-06-20 13:25:57.72 Code: 0xC0202020 Source: Validate File Product Families Source [1] Description: The buffer type is not valid. Make sure the Pipeline layout and all components pass validation. End Error Error: 2012-06-20 13:25:57.72 Code: 0xC004701A Source: Validate File SSIS.Pipeline Description: component "Product Families Source" (1) failed the pre-execute phase and returned error code 0xC0202020. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:25:49 PM Finished: 1:25:57 PM Elapsed: 8.5 seconds. The package execution failed. The step failed.

  Development environment is BIDS 2008 and SQL Server is 2008 R2.

  Can anybody please help me out with this?

  Thanks in advance.

  Thanks.

  Gunjan.

• manojp.nayak

  Grasshopper

  Points: 11

  More actions

  August 18, 2016 at 6:22 am

  #1896125

  Hello I am facing the same issue. No where i fund a solution. How did you solve your problem.