tag:blogger.com,1999:blog-8944073588702789702.post2787145217238734246..comments2024-02-07T10:25:15.051+00:00Comments on Business Intelligence Blog (BI Blog): SSIS - Execute a package from an ASP.NET pagePedrohttp://www.blogger.com/profile/14566879859258428850noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-8944073588702789702.post-67068122105698295212008-04-07T04:58:00.000+01:002008-04-07T04:58:00.000+01:00Dear Pedro,It was a good and useful post.Is it pos...Dear Pedro,<BR/>It was a good and useful post.<BR/>Is it possible to catch the warnings, and failure messages that are produced through SSIS Packages?<BR/>Thanks,<BR/>Amin<BR/><BR/>14 February, 2008 09:29<BR/>----------------------------<BR/>Dear Pedro,<BR/>It is OK, but I meant Is it possible to catch them within your ASP.net codes?<BR/>For example imagine that you are going to represent how many rows were affected by the action that user has submited.<BR/><BR/>many thanks,<BR/>Amin<BR/><BR/>15 February, 2008 19:46<BR/>----------------------------<BR/>Dear Pedro,<BR/>Thank you very much for this post and the answers.<BR/><BR/>Cheers friend,<BR/>Amin<BR/><BR/>16 February, 2008 15:39<BR/>----------------------------<BR/>Dear Pedro,<BR/>I read a little about it.<BR/>Unfortunately I cannor register for it because of lots of tasks that I have to do and the lack of time. :-(<BR/>But I hope you can participate in it and heard you alot about it.<BR/><BR/>Thanks,<BR/>Amin<BR/><BR/>17 February, 2008 13:05<BR/>----------------------------<BR/>Dear Pedro,<BR/>I am in Iran. Why do you think that I am in UK??<BR/>Regards,<BR/>Amin<BR/><BR/>18 February, 2008 04:14Aminhttps://www.blogger.com/profile/00371695808163855862noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-50256076664785449372008-02-18T19:20:00.000+00:002008-02-18T19:20:00.000+00:00Dear Amin, Because you told me some weeks ago that...Dear Amin, <BR/>Because you told me some weeks ago that would like to go to england! Nothing special! :-)<BR/>I will be in UK next 1ºMarch for the SQLBits... You dont like to go?! See www.sqlbits.com!!!<BR/>Cheers!!!Pedrohttps://www.blogger.com/profile/14566879859258428850noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-73317679633687670912008-02-18T04:14:00.000+00:002008-02-18T04:14:00.000+00:00This comment has been removed by the author.Aminhttps://www.blogger.com/profile/08466387204069727117noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-22574326576921030942008-02-17T13:07:00.000+00:002008-02-17T13:07:00.000+00:00Dear Amin, But right now you are in UK or in Iran?...Dear Amin, <BR/>But right now you are in UK or in Iran?!<BR/>Regards!!<BR/>:-)Pedrohttps://www.blogger.com/profile/14566879859258428850noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-55269210236104334732008-02-17T13:05:00.000+00:002008-02-17T13:05:00.000+00:00This comment has been removed by the author.Aminhttps://www.blogger.com/profile/08466387204069727117noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-14323118905129913942008-02-16T15:52:00.000+00:002008-02-16T15:52:00.000+00:00Dear Amin,it's a pleasure!Do you know about SQL Bi...Dear Amin,<BR/>it's a pleasure!<BR/>Do you know about SQL Bits conference next 1ºMarch on Birmingham (UK)? I'm trying to get my confirmation but will be dificult because there are about 500 people registered!!! Do you go?<BR/>Regards!Pedrohttps://www.blogger.com/profile/14566879859258428850noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-13848891196484640782008-02-16T15:39:00.000+00:002008-02-16T15:39:00.000+00:00This comment has been removed by the author.Aminhttps://www.blogger.com/profile/08466387204069727117noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-48464988875697445902008-02-16T06:15:00.000+00:002008-02-16T06:15:00.000+00:00Pedro, Your post was very useful. I had this ques...Pedro,<BR/> Your post was very useful. I had this question in my mind but never tried. You already have that posted ! .. Great..<BR/><BR/>Thanks<BR/>Subhash SubramanyamSubhash Subramanyamhttps://www.blogger.com/profile/00858447119974124831noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-48839335184958007922008-02-15T19:58:00.000+00:002008-02-15T19:58:00.000+00:00Dear Amin,Yes... I never tried, but yes.When the u...Dear Amin,<BR/>Yes... I never tried, but yes.<BR/>When the user do the request from the ASP.NET page, the log provider of the SSIS Package can save several events like:<BR/>StartDateTimeRunPackage<BR/>EndDateTimeRunPackage<BR/>Error and other kind of messages like information, on attention...<BR/><BR/>If you want to know the rows inserted for the user, you must do some customization using the event handlers on the SSIS Package. Example: adding an sql task to the event handler postExecute to save the rows inserted in the task or in the container. <BR/><BR/>Always depend on what you need to do.<BR/>Regards!!! :-)Pedrohttps://www.blogger.com/profile/14566879859258428850noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-67977805682869080962008-02-15T19:46:00.000+00:002008-02-15T19:46:00.000+00:00This comment has been removed by the author.Aminhttps://www.blogger.com/profile/08466387204069727117noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-54125970237678291032008-02-14T20:26:00.000+00:002008-02-14T20:26:00.000+00:00Dear Amin,You can catch the warning, information a...Dear Amin,<BR/>You can catch the warning, information and error messages if you activate the log provider of your SSIS package. Doing that you can save these messages in a database, textfile or other.<BR/>Cheers friend!!!<BR/>PedroPedrohttps://www.blogger.com/profile/14566879859258428850noreply@blogger.comtag:blogger.com,1999:blog-8944073588702789702.post-24812755643841058002008-02-14T09:29:00.000+00:002008-02-14T09:29:00.000+00:00This comment has been removed by the author.Aminhttps://www.blogger.com/profile/08466387204069727117noreply@blogger.com