tag:blogger.com,1999:blog-2379842053067321961.post7210523611709310107..comments2024-03-28T13:24:50.042-07:00Comments on Welcome To TechBrothersIT: How to Read Excel Sheet Data after Skipping Rows in SSIS Package by using Script Task - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-2379842053067321961.post-34684145030967402262023-11-06T07:00:43.100-08:002023-11-06T07:00:43.100-08:00I find your tutorial wonderful and very helpful. ...I find your tutorial wonderful and very helpful. My C# skills are beginner and I am stuck. I have multiple sheets in each excel file (.xls) but sometimes either one could be empty. I keep getting error/failure when the package runs. How would I/where would I in your code, add a part that if the sheet has no records, go on to the next sheet or continue on with the package?TDWilso3https://www.blogger.com/profile/05111148816339588666noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-1624833125886576072022-02-15T18:16:42.082-08:002022-02-15T18:16:42.082-08:00Alex , i have same problem do you have the code wh...Alex , i have same problem do you have the code which works correctly . can you post it hereAnonymoushttps://www.blogger.com/profile/03473188958968044929noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-41587553901084422862022-02-15T18:13:42.808-08:002022-02-15T18:13:42.808-08:00I am getting the same error as well. I am getting the same error as well. Anonymoushttps://www.blogger.com/profile/03473188958968044929noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-28651109350726100842021-06-23T10:27:47.432-07:002021-06-23T10:27:47.432-07:00It was wondering if I could use this write-up on m...It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks <a href="https://www.lithuaniaprinting.com/labels/" rel="nofollow">labels</a><br />saniyaahttps://www.blogger.com/profile/16233352748184000755noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-19195594014300677262020-12-02T07:47:40.886-08:002020-12-02T07:47:40.886-08:00I just thought it may be an idea to post incase an...I just thought it may be an idea to post incase anyone else was having problems researching but I am a little unsure if I am allowed to put names and addresses on here. <a href="https://www.cblaketahoe.com" rel="nofollow">here</a><br />haalihttps://www.blogger.com/profile/17694397367457169107noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-76531306225801055652020-11-30T06:44:43.055-08:002020-11-30T06:44:43.055-08:00getting syntax error Syntax error in query express...getting syntax error Syntax error in query expression 'Select Select STUFF((Select ',['+Column_Name+']' from Information_schema.Columns where Table_Name='CatsData3' and Table_SChema='dbo'and Column_Name in ('EmplApplName','PersNo','DAS','Tower','Subtower','Date','Status','FS') for xml path('')),1,1,'') From Sheet1$ on line adp1.Fill(dt1)<br />VGTulahttps://www.blogger.com/profile/02981735273851279066noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-80225540960540897392020-09-10T01:15:59.184-07:002020-09-10T01:15:59.184-07:00Thanks for the nice blog. It was very useful for m...Thanks for the nice blog. It was very useful for me. I'm happy I found this blog. Thank you for sharing with us,I too always learn something new from your post. <a href="https://readnovelfull.com/hidden-marriage.html" rel="nofollow">hidden marriage</a>mastoomhttps://www.blogger.com/profile/14324188058711592603noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-5338525702189082442020-06-08T00:38:56.898-07:002020-06-08T00:38:56.898-07:00I really thank you for the valuable info on this g...I really thank you for the valuable info on this great subject and look forward to more great posts. Thanks a lot for enjoying this beauty article with me. I am appreciating it very much! Looking forward to another great article. Good luck to the author! All the best! <a href="https://buyiglikes.com/product/buy-real-instagram-likes-cheap/" rel="nofollow">buy insta likes</a>albina N murohttps://www.blogger.com/profile/08139646674252673476noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-51337737120155816012020-05-23T10:45:37.900-07:002020-05-23T10:45:37.900-07:00When you use a genuine service, you will be able t...When you use a genuine service, you will be able to provide instructions, share materials and choose the formatting style. <a href="https://360digitmg.com/data-blending-in-tableau" rel="nofollow">Tableau Data Blending</a><br />M. Tahahttps://www.blogger.com/profile/12045558659892762964noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-39338926975211575142020-03-25T13:59:23.964-07:002020-03-25T13:59:23.964-07:00I have this sorted now.
I've relabeled my work...I have this sorted now.<br />I've relabeled my worksheets so that there are no spaces in the names (I'll deal with that on the client side later).<br /><br />This final table insert was giving me errors::<br /> BC.WriteToServer(dt1);<br /><br />I found this online and it works for me::<br /> BC.WriteToServer(dt1, DataRowState.Unchanged);<br /><br />Now I'm writing multiple worksheets to my single SQL Server table.<br /><br />I had an issue with column mapping. It's wasn't lining up. All columns were being written, but in a completely random order.<br /><br />These lines are very important for getting that working::<br /> foreach (var column in dt1.Columns)<br /> BC.ColumnMappings.Add(column.ToString(), column.ToString());<br /><br /><br />-Dave.Alexhttps://www.blogger.com/profile/17079099410486659888noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-22041196564079533142020-03-25T13:52:46.767-07:002020-03-25T13:52:46.767-07:00This comment has been removed by the author.Alexhttps://www.blogger.com/profile/17079099410486659888noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-56883861954949534392020-03-25T13:24:00.458-07:002020-03-25T13:24:00.458-07:00This comment has been removed by the author.Alexhttps://www.blogger.com/profile/17079099410486659888noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-6475062295468319362020-03-25T10:48:24.916-07:002020-03-25T10:48:24.916-07:00A little more on this.
It seems that the OleDbConn...A little more on this.<br />It seems that the OleDbConnection cnn using OleDbCommand oconn has single quotes in the sheet name (seems to be related to spaces in the sheet name)<br />This appears to cause an error, as 'sheet1$' doesn't parse like sheet1$.<br />Now, I'm trying to string.Remove the single quotes in the name of the sheet.<br /><br />Anyone else had this issue?<br /><br />-Dave.Alexhttps://www.blogger.com/profile/17079099410486659888noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-18629269054900701652020-03-24T15:17:34.188-07:002020-03-24T15:17:34.188-07:00Hello there, I'm trying to implement this exac...Hello there, I'm trying to implement this exact logic.<br />I'm on SQL Server 2016 using VS Enterprise 2015.<br />I'm getting an error on this line:: adp.Fill(dt);<br />I have commented out all lines, then uncommented them one by one and building and running the script task.<br />This line is throwing this error::<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()<br /><br />I'm googling it now to see what I can find.<br />Any suggestions?<br />-Dave.Alexhttps://www.blogger.com/profile/17079099410486659888noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-57442392034377468332019-06-19T13:59:21.271-07:002019-06-19T13:59:21.271-07:00did you find a solution for it?
did you find a solution for it?<br />BusinessSavvyAnalyticshttps://www.blogger.com/profile/12042057833101779234noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-34340706703385919152019-06-19T13:58:54.673-07:002019-06-19T13:58:54.673-07:00I am looking for dynamically finding the column an...I am looking for dynamically finding the column and row where the headers start<br />BusinessSavvyAnalyticshttps://www.blogger.com/profile/12042057833101779234noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-64838910113477168042019-04-30T00:15:45.062-07:002019-04-30T00:15:45.062-07:00In starting you are hardcoding raw and column posi...In starting you are hardcoding raw and column positions. Is it possible to get the positions of the header dynamically? Anonymoushttps://www.blogger.com/profile/01183449788627474875noreply@blogger.com