Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2012-06-13 : 13:33:39
|
| hi,i need to load 3 files every day,and the name for each of them is changed.the problem is when i do'nt have excel source file,so the all the pachage is faild,and i want that other 2 excel soource will be loading. how can i do it?this is errorTITLE: Package Validation Error------------------------------Package Validation Error------------------------------ADDITIONAL INFORMATION:Error at Clallit [Excel Source [1]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine could not find the object 'Data$'. Make sure the object exists and that you spell its name and the path name correctly.".Error at Clallit [Excel Source [1]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.Error at Clallit [SSIS.Pipeline]: "component "Excel Source" (1)" failed validation and returned validation status "VS_ISBROKEN".Error at Clallit [SSIS.Pipeline]: One or more component failed validation.Error at Clallit: There were errors during task validation. (Microsoft.DataTransformationServices.VsIntegration)------------------------------BUTTONS:OK------------------------------ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-13 : 15:25:08
|
| set FailPackageOnFailure property of task to be false and then use on completion as condition for precedence constraint for data flow task------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
excel file