tag:blogger.com,1999:blog-2379842053067321961.post2862424439027509321..comments2024-03-29T02:42:58.208-07:00Comments on Welcome To TechBrothersIT: How to Load Excel Files with Single/ Multiple Sheets to SQL Server Tables according to Excel File Name Dynamically - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2379842053067321961.post-31834943335044256632022-10-07T04:29:30.355-07:002022-10-07T04:29:30.355-07:00Script fail if I have .xlxs file which is not in I...Script fail if I have .xlxs file which is not in Information_schema.Columns Table_Name. How I can solve this ? How can I import multiple excel files with different Table_Schema ? great work btw :)Michal Simalhttps://www.blogger.com/profile/09134155633121559964noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-18375971313258419262019-06-17T16:53:46.545-07:002019-06-17T16:53:46.545-07:00Hi, I got an error while running the script..wonde...Hi, I got an error while running the script..wondering if you could advice ...thank you very much...<br /><br />" at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)<br /> at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)<br /> at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)<br /> at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)<br /> at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()"Anonymoushttps://www.blogger.com/profile/01331721464599504955noreply@blogger.com