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 |
|
theboyholty
Posting Yak Master
226 Posts |
 Posted - 2013-03-22 : 06:44:35
|
| I've written a package to loop through around 1000 spreadsheets and import them into SQL. It runs fine in visual studio but when I run it as a SQL Agent job, it fails.The errors relate to the VS_NEEDSNEWMETADATA on a couple of the import tasks. I can't understand why it only throws these errors when run as a job and works when run locally.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-22 : 06:59:32
|
| Have you set any connection configuration for the folder path? Is the path containing files accessible for the account that sql agent job uses.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
theboyholty
Posting Yak Master
226 Posts |
Posted - 2013-03-22 : 07:26:06
|
| Well the thing is (and I probably should have mentioned this originally), most of the spreadsheets do import successfully.---------------------------------------------------------------------------------http://www.mannyroadend.co.uk A Bury FC supporters website and forum |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-22 : 13:34:28
|
| so are you telling that error happens intermittendly? then it might be issue with those sheets. If metadata is different for them it will surely break with above error.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
needs new meta data errors