MicrosoftGetting this error when trying to copy data from "Teradata Source" to "OLE DB Destination" (MSSQL Server). Have adjusted "JobMaxRowSize" and tried to change the "DiscardLargeRow" to both true and false. ANy suggestions?
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [Teradata Source [16]]: The "Teradata Source" is missing the required property "JobMaxRowSize". The object is required to have the specified custom property.
Error at Data Flow Task [SSIS.Pipeline]: "Teradata Source" failed validation and returned validation status "VS_ISCORRUPT".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
===================================
Error at Data Flow Task [Teradata Source [16]]: The "Teradata Source" is missing the required property "JobMaxRowSize". The object is required to have the specified custom property.
Error at Data Flow Task [SSIS.Pipeline]: "Teradata Source" failed validation and returned validation status "VS_ISCORRUPT".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
