InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 02:52:38 GMT20http://www.sqlservercentral.com/Forums/Topic1370816-146-1.aspxI assume you have a bunch of .sql files in a folder that you want to execute. What you can do is use a foreach loop container in SSIS and get the name of file in a variable.Then inside foreach loop, place an execute sql task with SQLSourcetype as FileConnection. Configure the Connectionstring property of Connection manager of this Fileconnection to read value from variable being used in foreach loop container.If any of the script fails, package will fail.Hope this helps !!Wed, 10 Oct 2012 04:42:26 GMTRavi Chhabriahttp://www.sqlservercentral.com/Forums/Topic1370816-146-1.aspxUse a Foreach Loop Container in SSIS. Your requirements are quite vague, so please try that and post again if there's anything in particular that you don't understand.JohnWed, 10 Oct 2012 04:27:29 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1370816-146-1.aspxI need to know how to execute batch of scripts stored in some folder one by one through DTS or SSIS or is there is one script which execute all bunch from folder and if error occours then STOP at that POINT and SHOW ERROR WITH THAT PERTICULAR SCRIPT NAMEWed, 10 Oct 2012 04:13:00 GMThimanshuk