开发者

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!

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜