InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:50:54 GMT20http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxEven after I moved Microsoft.Office.Interop.Excel.dll file to GAC (C:\Windows\Assembly) folder, I'm still not able add it as a reference to my script task. Do I need to reboot the server?Sun, 04 Dec 2011 18:33:05 GMTJay1234http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxI am loading 5 different csv files into sqlserver db (into one table) by using 5 data flow tasks (each data flow for each csv), I am doing this monthly once manually. Would you please explain me how I need to automate this process.Another thing is, how we can load csv file into sharepoint URL by using SSIS.Its a kind of urgent...........Advanced ThanksTue, 18 Aug 2009 01:53:52 GMTvasu_sql-1092310http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxHow can I find status of a job in SSIS?Fri, 25 Jan 2008 04:01:40 GMTashish sinha-404083http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxIt is a great article! :Wow:Thanks for sharing a bunch of knowledge. On my part, I would like to know that how much time the whole process took you to complete?I know that it depends upon many factors, but suppose you are ready with the requirement then what the time will be.I liked the way of scheduling, however this is the first time I have come across any job scheduling defined from database.Thanks.Mon, 05 Nov 2007 01:11:24 GMTJwalant Natvarlal Sonejihttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxThe issues with the ZIP file were the editor's (my) fault. They have been corrected and my apologies.Tue, 30 Oct 2007 12:11:27 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspx[quote][b]Christopher West (10/30/2007)[/b][hr]I don't understand, if this is a monthly process why not just schedule it to run every month?[/quote]Because of this:The user requirement is described as follows: 1. Client gets extracts from five different source systems (.txt, .csv and .xls file) every month on [b]different weekdays[/b].Tue, 30 Oct 2007 11:48:15 GMTAlex Diaz-329446http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxBecause of this:The user requirement is described as follows: 1. Client gets extracts from five different source systems (.txt, .csv and .xls file) every month on [b]different weekdays[/b].Tue, 30 Oct 2007 11:43:29 GMTAlex Diaz-329446http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxThank you very much for your post - it coincidentally occurs at the same time as a major project that is very much an analog to it has been handed over to me for maintenance and execution. Your post will be my late night reading for the next few days. Thanks again - it was fortuitous to come across your posting. Mike :)Tue, 30 Oct 2007 11:01:14 GMTMichael F. Udrowhttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxFor all members:The enclosed two issued have been resolved by SSC team.1. Uploaded automation.zip folder.2. Store SP OthCalculateNextDate in a separate box You can use the example along with an article now.Tue, 30 Oct 2007 09:22:09 GMTVijaya Kumar Gulappahttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxThanks for having SSC get the file attached to the article.Tue, 30 Oct 2007 08:08:28 GMTPhil-94129http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxNo such thing as a mistake - its called deployment testing....Tue, 30 Oct 2007 07:25:54 GMTferigodhttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxFor all members:There are two issues need to be corrected by SSC team.1. I had provided automation.zip folder. SSC team has forgotten to upload the same. I will follow-up with SSC team to upload the file now.2. I will ask SSC team to store the SP OthCalculateNextDate in a separate box as ConCheckHolidayThank you for your commentsTue, 30 Oct 2007 07:23:36 GMTVijaya Kumar Gulappahttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxIt appears that the author did not include a link to the "Automation" zip folder that contains the dbscript.sql, SSIS package, and extract files.These would be helpfull in order to work through the examples in the article.ThanksTue, 30 Oct 2007 07:02:31 GMTPhil-94129http://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxI don't understand, if this is a monthly process why not just schedule it to run every month?Tue, 30 Oct 2007 07:02:04 GMTChristopher Westhttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxYes, I can't find automation file mentioned in the article either, pls someone tell me where I can find the zip file.Thanks,PyayTue, 30 Oct 2007 03:16:52 GMTPyay Nyeinhttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxCan you put SP OthCalculateNextDate in separate box as ConCheckHoliday just to make it readable?Tue, 30 Oct 2007 01:03:39 GMTNebojsa Ilichttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxunable to locate the automation file mentioned in the articleTue, 30 Oct 2007 00:20:01 GMTferigodhttp://www.sqlservercentral.com/Forums/Topic416303-172-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Integration+Services/61260/">SQL Server Integration Services Automation</A>[/B]Tue, 30 Oct 2007 00:05:49 GMTVijaya Kumar Gulappa