troubleshooting Question

SSIS package error on Sybase ADO NET SOUCE load in to SQL SERVER

Avatar of kbennett13
kbennett13Flag for United States of America asked on
Sybase DatabaseMicrosoft SQL Server 2008
5 Comments1 Solution2029 ViewsLast Modified:
 Attempting to import data from sybase to SQL Server. I Created a SSIS Pacakge with a ADO Net Source with Datasource connection like so  Data Source I created
and I get a test that is successful like so
 The test connection however when i try to run the package i get this error
 The error
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "ADO NET Source" (1243) failed validation and returned error code 0x80131937.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.

Any help of how to get rid of this error.
ASKER CERTIFIED SOLUTION
kbennett13

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros