tag:blogger.com,1999:blog-2379842053067321961.post300999654497781733..comments2024-03-29T04:34:24.750-07:00Comments on Welcome To TechBrothersIT: SSIS Tutorial Part 23 - Read Files as per Extension and Load them to a SQL Server Table in SSIS PackageAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2379842053067321961.post-80083443090160123732020-09-29T09:54:17.166-07:002020-09-29T09:54:17.166-07:00YO TAMBIEN PASO POR LO MISMO, PODRIA HACER UN CON ...YO TAMBIEN PASO POR LO MISMO, PODRIA HACER UN CON VISUAL STUDIO 2019 ? LUIS techttps://www.blogger.com/profile/13661340383497198295noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-68931877460368181922019-09-02T02:36:59.724-07:002019-09-02T02:36:59.724-07:00Use excel file path in expression provide the comp...Use excel file path in expression provide the complete excelpath/filename.ext and keep the delay validation true. Once package is scheduled then automatically package will pick the dynamic excel file which is coming daily in your folder and load the data.<br /><br />I have tried this and worked in my case.Anonymoushttps://www.blogger.com/profile/07371754205651358986noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-25262188284853003932019-08-20T10:52:20.033-07:002019-08-20T10:52:20.033-07:00I did flat file source in SSIS package. But I alwa...I did flat file source in SSIS package. But I always failed to go through this.Anonymoushttps://www.blogger.com/profile/09258887842641831674noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-29589127218238951752019-02-12T09:00:04.682-08:002019-02-12T09:00:04.682-08:00Why same concept not working for the Excel files. ...Why same concept not working for the Excel files. I am getting new excel files every day and I need to dump the data from Excel to SQL Server, I tried so many solutions but all are giving errors for Connection string. I also tried to use the ExcelFilepath instead of Connection String but nothing working Krishnahttps://www.blogger.com/profile/09287388842095858489noreply@blogger.com