tag:blogger.com,1999:blog-2379842053067321961.post878943371440524582..comments2024-03-28T10:19:00.804-07:00Comments on Welcome To TechBrothersIT: How to create Excel File Dynamically from SQL server Table/View by using Script Task in SSIS Package - SSIS TutorialAamir Shahzadhttp://www.blogger.com/profile/16777994869678463807noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-2379842053067321961.post-69975430707253914412022-01-22T03:45:01.141-08:002022-01-22T03:45:01.141-08:00Master Excel 2016 Essential Skills is very much or...Master Excel 2016 Essential Skills is very much organized with simple to follow meetings and examples. One thing you will see straight away is that the book is bigger than numerous other Excel books. <a href="https://www.indianschoolsdatabase.com/indian-college-placement-cell-email-database-6k-entries/" rel="nofollow">placement cells database</a><br />Rooniehttps://www.blogger.com/profile/12419480929304968835noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-38539880280780925602022-01-11T03:40:49.462-08:002022-01-11T03:40:49.462-08:00This Article is Awesome. It’s helped me a lot. Ple...This Article is Awesome. It’s helped me a lot. Please keep up your good work. We are always with you and Waiting for your new interesting articles. <a href="https://www.dynamicpackaging.software/system-software-tool/" rel="nofollow">Dynamic Packaging System Software</a>.mfdentalhttps://www.blogger.com/profile/00277967837516371044noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-83287919638315531892021-12-29T09:05:33.067-08:002021-12-29T09:05:33.067-08:00This is very informative and interesting for me. T...This is very informative and interesting for me. Thank you for such a wonderful article and for sharing. God bless you. We also provide service for <a href="https://www.dynamicpackaging.software/" rel="nofollow">Travel Portal System With Dynamic Packaging</a> for more info visit our website.VAT Registrationhttps://www.blogger.com/profile/17182397535802999528noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-80875718557389777752021-12-17T13:18:35.261-08:002021-12-17T13:18:35.261-08:00Worked great, thanks for posting!Worked great, thanks for posting!Anonymoushttps://www.blogger.com/profile/17725460145931322709noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-9747002462782330222021-11-17T00:40:49.656-08:002021-11-17T00:40:49.656-08:00Excellent article. However I am facing the below e...Excellent article. However I am facing the below error:<br />"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."<br /><br />Pretty sure the Microsoft.ACE.OLEDB.12.0 is registered and works for other SSIS packages. I inserted the $ in sheetname too. Still couldnt resolve the above errorRandomAccesshttps://www.blogger.com/profile/02977280700644921934noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-91993923120326433762021-11-10T16:32:22.439-08:002021-11-10T16:32:22.439-08:00I Need write table in existing excel template with...I Need write table in existing excel template with out creating new excel sheet . Also table also come with dynamic filedsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-92116307975798549772021-09-22T10:51:24.790-07:002021-09-22T10:51:24.790-07:00the modification below worked for me.
columnvalue...the modification below worked for me. <br />columnvalues += "'" + table.Rows[index].ItemArray[i].ToString().Replace("'", "''") + "',";<br />Good luck!<br /><br /> <br /><br />foreach (DataRow row in table.Rows)<br /> {<br /> string columnvalues = "";<br /> for (int i = 0; i < columnCount; i++)<br /> {<br /> int index = table.Rows.IndexOf(row); <br /> columnvalues += "'" + table.Rows[index].ItemArray[i].ToString().Replace("'", "''") + "',";<br /><br /> }<br /> columnvalues = columnvalues.TrimEnd(',');<br /> var command = sqlCommandInsert + columnvalues + ")";<br /> Excel_OLE_Cmd.CommandText = command;<br /> Excel_OLE_Cmd.ExecuteNonQuery();<br /> }Anonymoushttps://www.blogger.com/profile/13323060279180734962noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-41169434310523408242021-08-03T03:53:38.100-07:002021-08-03T03:53:38.100-07:00Not easy to fix with table names containing quotes...Not easy to fix with table names containing quotes in their name, as strings are used throughout this code. Can you create a view that selects from the table and run the code against the view?Harjhttps://www.blogger.com/profile/09734081629921793872noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-30415322172156727882021-08-03T02:12:40.618-07:002021-08-03T02:12:40.618-07:00I have a problem with data in a sql table that con...I have a problem with data in a sql table that contains the ' character in its name.<br />What to correct in the code so that this error is not there?Styranyhttps://www.blogger.com/profile/13528441339055039697noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-33609072670772094902021-04-28T06:18:35.537-07:002021-04-28T06:18:35.537-07:00Hi! I'm try start your code, but i have read-w...Hi! I'm try start your code, but i have read-wrute error. Can you help me with next error:<br />System.Data.OleDb.OleDbException (0x80004005): cannot update. database or object is read-onlyret32https://www.blogger.com/profile/06138836051627278216noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-9226646751436514352021-03-17T04:38:56.783-07:002021-03-17T04:38:56.783-07:00Thanks for this. Helped me out a lot!Thanks for this. Helped me out a lot!Harjhttps://www.blogger.com/profile/09734081629921793872noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-71561703345931364962020-12-30T22:51:19.667-08:002020-12-30T22:51:19.667-08:00The structure will permit you to make an Excel art...The structure will permit you to make an Excel article and control a portion of the essential functionalities, for example, getting worksheet data and extricating information from the worksheet given a reach. <br /><a href="https://www.am18.co.uk/how-microsoft-excel-experts-can-help-your-business/" rel="nofollow">Excel spreadsheet consultant</a><br />NOAHhttps://www.blogger.com/profile/01728101238786633823noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-26449124413032796722020-11-17T06:13:37.812-08:002020-11-17T06:13:37.812-08:00facing the below error
System.Data.OleDb.OleDbExc...facing the below error<br /><br />System.Data.OleDb.OleDbException (0x80004005): IErrorInfo.GetDescription failed with E_FAIL(0x80004005)Manojhttps://www.blogger.com/profile/04405907069877272903noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-8565807520971395022019-11-02T11:40:14.166-07:002019-11-02T11:40:14.166-07:00Hi,
Is it possible to have numeric values displaye...Hi,<br />Is it possible to have numeric values displayed as numbers, not as strings in the excel?NMGRhttps://www.blogger.com/profile/17420213265122483962noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-67561242070385759162019-10-02T03:04:49.344-07:002019-10-02T03:04:49.344-07:00Hi I'm also having the issue where the package...Hi I'm also having the issue where the package is throwing the syntax error Syntax error (missing operator) in query expression where there are single quotes in the text. Is there a solution for this? Many thanksShameerhttps://www.blogger.com/profile/06185391296750969103noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-79769474949260390562019-10-02T03:02:29.866-07:002019-10-02T03:02:29.866-07:00This comment has been removed by the author.Shameerhttps://www.blogger.com/profile/06185391296750969103noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-36176063260243866172019-09-20T23:07:36.837-07:002019-09-20T23:07:36.837-07:00Ace4sure is the website that deals in preparation ...Ace4sure is the website that deals in preparation material for the exam for many years. According to my exposure and research, this is the right platform where you can get exact <a href="https://www.ace4sure.com/HPE6-A42-questions.html" rel="nofollow">HPE6-A42 Dumps Questions</a>.carishttps://www.blogger.com/profile/13158233182271637812noreply@blogger.comtag:blogger.com,1999:blog-2379842053067321961.post-86787432835133356222019-08-19T04:31:51.389-07:002019-08-19T04:31:51.389-07:00Thanks , this works well. But i do have some value...<br />Thanks , this works well. But i do have some values which has quotes in between the text, like Australian Int'l School. The code fails with the following error for such records. What change can be done to correct this?<br /><br />Syntax error (missing operator) in query expression ''Australian Int'l SchoolAnonymoushttps://www.blogger.com/profile/16354133006259197251noreply@blogger.com