SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 needs new meta data errors
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

theboyholty
Posting Yak Master

United Kingdom
221 Posts

Posted - 03/22/2013 :  06:44:35  Show Profile  Visit theboyholty's Homepage  Reply with Quote
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

India
52317 Posts

Posted - 03/22/2013 :  06:59:32  Show Profile  Reply with Quote
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

United Kingdom
221 Posts

Posted - 03/22/2013 :  07:26:06  Show Profile  Visit theboyholty's Homepage  Reply with Quote
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

India
52317 Posts

Posted - 03/22/2013 :  13:34:28  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000