July 16, 2007 at 7:11 pm
I have a Data Flow Task inside a ForEachLoop Container.
The DataFlow Task is a basic Data insert between a Excel spreadsheet to a Table in a SQL Server 2005 Database.
The ForEachLoop Container has a User Variable assigned to basically see if the Excel file exists.
The problem is that if I add the User Variable to the properties of the Excel Connection, I get the error below. But if remove the User Variable from the Properties of the Excel Connection, it works.
Can anyone shed some light on this? Is this a common problem?
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Data Flow Task [Excel Source [1]]: The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
Error at Data Flow Task [DTS.Pipeline]: component "Excel Source" (1) failed validation and returned error code 0xC020801C.
Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
Error at Package [Connection manager "Excel Connection Manager"]: An OLE DB error has occurred. Error code: 0x80040E4D.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
July 17, 2007 at 2:31 am
Set the Delay Validation to true. It's complaining about a blank value. Delaying validation should solve it.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
July 17, 2007 at 3:55 pm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply