ssis package from SQL agent failed
I have simple package which reads data from csv file and loads into SQL table. File is located on another server and it is shared. I use UNC path in package. package is scheduled using sql agent job. Job worked fine for 1 week and suddenly started giving error "The file name "\\124.0.48.173\basel2\Commercial\Input\ACBS_GSU.csv" specified in the connection was not va开发者_JS百科lid. End Error Error: 2010-04-20 16:15:07.19 Code: 0xC0202070 Source: ACBS_GSU Connection manager "CSV file conection" Description: Connection "CSV file conection" failed validation."
Any help will be appreciated.
Sounds like SMB connection timeout. Are you traversing a firewall to reach the target?
Can't believe but after banging my head for whole day we restarted the server and it worked. Now I know one thing for sure for any problem that seems to be irrational solution is Restart!
精彩评论