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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 needs new meta data errors

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -