If files are not exists in the folder it shows a message as No Files Exists.
Hi All, I have a requirement to load the multiple files data into sql server through Job in Sql server Agent. if there is no files are avilable in contained folder it gives an error message as "No Files Exist in Contained folder" using Script task in SSIS. Regards, Praveen C.
January 22nd, 2012 12:57am

Hi, 1.Modify your script task to get the number of files in the directory . 2.use the variable in the precedence constraint to check if @Var>1 . Look into this links http://msdn.microsoft.com/en-us/library/wt8k42e9%28v=vs.80%29.aspx http://www.simple-talk.com/sql/ssis/working-with-precedence-constraints-in-sql-server-integration-services/Rakesh M J | MCTS,MCITP ( SQL SERVER 2008 ) Dont forget to mark it as Answered if found useful | myspeakonbi
Free Windows Admin Tool Kit Click here and download it now
January 22nd, 2012 2:00am

Hi, the above post byRakesh M J is very helpful but, if there is many files come while your package is working then you have the wrong number. So in addition I think your variable must be assigned after any iteration or when it comes to zero (but after each iteration is better for me). I hope this is helpful. Elmozamil Elamir MyBlogPlease Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem Elmozamil Elamir Hamid http://elmozamil.blogspot.com
January 22nd, 2012 5:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics