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 |
|
nicky_river
Yak Posting Veteran
55 Posts |
 Posted - 2010-08-19 : 08:22:25
|
| Hi Everyone,if the excelsheet path is changed then how can we execute a package. It is giving an error when the path of the excelsheet is changed or name of the excelsheet is changed.Anyone please tell me how to go about solving this error |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-19 : 09:00:01
|
| If reading from your excel is not cruical for your SSIS package, than you have to do at least two things:- on your excel datasource | database destination - set "delay validation" to true- and set your connections in control panel window from green to blue -> from successfull to completion; meaning that even if data flow task is unsuccessfull, it will go on. |
 |
|
|
nicky_river
Yak Posting Veteran
55 Posts |
Posted - 2010-08-19 : 09:12:37
|
| Hi slimt_slimt,Thanks for your response.Could you provide me the steps on how to "delay validation" ?where do i need to set these connections in windows control panel or somewhere else ?running the excel sheet is crucial for me. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-19 : 14:03:27
|
quote:
Originally posted by nicky_river
Hi slimt_slimt,Thanks for your response.Could you provide me the steps on how to "delay validation" ?where do i need to set these connections in windows control panel or somewhere else ?running the excel sheet is crucial for me.
delay validation is a property which is available for excel source.How are you currently passing the name and path of file?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS dificulty