tag:blogger.com,1999:blog-3190166579815746224.comments2024-03-07T22:21:50.867-08:00SQL JourneyNisharhttp://www.blogger.com/profile/03151449590672654447noreply@blogger.comBlogger41125tag:blogger.com,1999:blog-3190166579815746224.post-31280578628397616722016-07-20T04:51:35.999-07:002016-07-20T04:51:35.999-07:00The code in UpdateDataSources_report assumes that ...The code in UpdateDataSources_report assumes that each data source returned from GetItemDataSources is a Shared Datasource. This causes false errors when deploying a report with an embedded data source. My reading of the namespace says there is a way to test the items returned from GetItemDataSources for DataSourceDefinition vs. DataSourceReference. Only a DataSourceReference data source would be linked to an external data source file. <br /><br />I've tried to update your code to implement this test but have been unsuccessful. Is this something you can look at?Rickhttps://www.blogger.com/profile/00883145205297985208noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-59210302380479016732016-06-07T15:30:01.016-07:002016-06-07T15:30:01.016-07:00You could add https://github.com/timabell/ssrs-pow...You could add https://github.com/timabell/ssrs-powershell-deploy to your listTim Abellhttps://www.blogger.com/profile/18329208508756809573noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-16581009356452455782015-11-09T03:35:37.734-08:002015-11-09T03:35:37.734-08:00Quick question
Is it possible to enter a SSRS use...Quick question<br /><br />Is it possible to enter a SSRS username and password to use for the deploy rather than the local account?sprotsonhttps://www.blogger.com/profile/13506989465266554729noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-78957334365684218242015-10-26T02:59:42.648-07:002015-10-26T02:59:42.648-07:00Nishar,
I want to create a Root Folder in Report ...Nishar,<br /><br />I want to create a Root Folder in Report Server, and under that I need to create various module folders. These module folders would have the reports, dataset and datasource folder.<br /><br />I am able to create the root level folder but when I try to create subfolder inside root folder "rs.CreateFolder" does not create a the same and gives error as "library!ReportServer_0-1!3778!10/26/2015-15:21:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: , Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemNameException: The name of the item 'test/Reports' is not valid. The name must be less than 260 characters long. The name must not start with slash; other restrictions apply.;"<br /><br />Please suggest, how we can resolve this.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-87811856251425650702015-10-23T03:42:25.175-07:002015-10-23T03:42:25.175-07:00Appreciate your work on this. However, I am facing...Appreciate your work on this. However, I am facing issue while deploying the SSRS report. I could login to the report server, but getting below error while the reports are getting copied. Please suggest what could be the problem.<br /><br /><br />Initiating Deployment<br /><br />Checking for Target Folders<br />The request failed with HTTP status 401: Unauthorized.<br /><br />Reading Files from Report Services Project<br />Attempting to Deploy Data Source XYZABCDE<br />In ReadFiles The request failed with HTTP status 401: Unauthorized.<br /><br />Regards,Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-3637748432483528182015-08-11T00:42:56.474-07:002015-08-11T00:42:56.474-07:00I really appreciate your work and it is quite info...I really appreciate your work and it is quite informative post thank you. <a href="http://www.optisolbusiness.com/servicess/analytics" rel="nofollow">SQL Server Integration Services</a>OptiSolhttps://www.blogger.com/profile/00878745616891332504noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-85566414746238852852015-05-13T05:05:22.036-07:002015-05-13T05:05:22.036-07:00Nishar,
Thank you for this script. It is working ...Nishar,<br /><br />Thank you for this script. It is working very well for me. I am wondering if you know of a way to delete all the reports/datasets but not the datasources prior to deploying the reports?<br />I have been trying to do this through vbscript but for some reason I cannot use the FileSystemObject in my environment and the rs.deleteitem works for an individual report but I would like a way to delete all the *.rdl and *.rsd. <br /><br />Thanks againCymbioticahttps://www.blogger.com/profile/18035854089387875264noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-89541008750516674412015-04-10T03:07:28.310-07:002015-04-10T03:07:28.310-07:00This comment has been removed by a blog administrator.Android training in chennaihttp://www.androidtraininginchennai.innoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-32970752164906601562015-04-10T03:05:52.525-07:002015-04-10T03:05:52.525-07:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-75103792257127372972015-04-10T03:03:03.423-07:002015-04-10T03:03:03.423-07:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-3826951694705110702015-04-07T23:04:56.732-07:002015-04-07T23:04:56.732-07:00This comment has been removed by a blog administrator.hadoop training in chennaihttp://www.besanttechnologies.com/training-courses/data-warehousing-training/hadoop-training-institute-in-chennainoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-57612887050863646842015-04-03T23:50:20.297-07:002015-04-03T23:50:20.297-07:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/16166968610225971638noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-91106479815034827252015-03-26T03:29:06.571-07:002015-03-26T03:29:06.571-07:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/01882839630037611834noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-26178012223495001172015-03-24T06:12:25.737-07:002015-03-24T06:12:25.737-07:00If you want to have an "Update" command ...If you want to have an "Update" command as well, check out SQL Server Management Studio and TortoiseSVN (http://www.jrummell.com/blog/2009/11/sql-server-management-studio-and-tortoisesvn/)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-70280040580920384172015-03-14T05:34:41.780-07:002015-03-14T05:34:41.780-07:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-29563376867343106202014-12-17T08:08:09.821-08:002014-12-17T08:08:09.821-08:00Good Day Everyone,
could anybody assist me in cre...Good Day Everyone,<br /><br />could anybody assist me in creating a Linked Report using a similar approach?<br /><br />Thank you for your help !donbuzhttps://www.blogger.com/profile/03414425542976210163noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-76467362451120195952014-11-16T23:08:46.716-08:002014-11-16T23:08:46.716-08:00Superb!Superb!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-45453922698589568372014-11-13T09:51:50.885-08:002014-11-13T09:51:50.885-08:00My report is not mapping to relative datasouce aft...My report is not mapping to relative datasouce after publish.<br />UpdateDatasource method is failing.<br />Can you please suggest?winnerhttps://www.blogger.com/profile/03363349668497741822noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-64106568183660518942014-11-12T02:40:24.308-08:002014-11-12T02:40:24.308-08:00greatgreatAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-79000867890440529972014-10-10T09:22:57.589-07:002014-10-10T09:22:57.589-07:00AuthenticationAuthenticationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-37465772845817737962014-10-10T09:21:19.775-07:002014-10-10T09:21:19.775-07:00in the tagin the tagAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-64491815955049525222014-09-23T21:52:00.102-07:002014-09-23T21:52:00.102-07:00nice thank you mate :)
it works.nice thank you mate :)<br />it works.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-37770526354533124502014-08-26T08:06:24.633-07:002014-08-26T08:06:24.633-07:00Sure Rick,
If you are interested send me and emai...Sure Rick,<br /><br />If you are interested send me and email to sebestin.dragos@gmail.comAnonymoushttps://www.blogger.com/profile/02708905475598735347noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-81513132300766654272014-08-25T08:47:44.142-07:002014-08-25T08:47:44.142-07:00Dragos,
Could you make your code available? I als...Dragos,<br /><br />Could you make your code available? I also need to deploy/publish image files along with RDL, Shared Datasources and Shared Datasets.<br /><br />Thanks.Rickhttps://www.blogger.com/profile/00883145205297985208noreply@blogger.comtag:blogger.com,1999:blog-3190166579815746224.post-12930787556570856432014-08-24T23:44:55.919-07:002014-08-24T23:44:55.919-07:00Sorry, long time since I read your post for the fi...Sorry, long time since I read your post for the first time.<br /><br />As a sidenote, I have made some improvements to your script (add posibility to deploy image files and also create subfolders for the files, e.g. specify the reports folder as /Reports/Accounting/Office2). If you would like to take a look, I would gladly send it to you, maybe it would help others.<br /><br />All the best,<br />DragosAnonymoushttps://www.blogger.com/profile/02708905475598735347noreply@blogger.com