Msbuild, TFS 2013, Sql 2012 and automating report deployment (Network Steve Forum)

Msbuild, TFS 2013, Sql 2012 and automating report deployment

This has been asked in so many ways, and in so many combinations, but I am unable to find this combination. We are using TFS 2013, and I would like to deploy the reports as part of the build process. I have found many articles / code on doing this with TFS 2012, but the build process has changed from xml files to workflow. I am comfortable using RsScripter, but it looks like it has been removed from the internet a while ago [found archive links], so finding the command line supporting documents isn't proving to be easy.

Surely I cannot be the only one who is trying to do this! I know I can use Rs.exe to accomplish it, but someone by now has had to do this already... I can easily get the .rdl files out of TFS into a working directory... It's generating the .rss file [which would go through and set the datasources properly] that is proving to be a bit tricky. RsScripter.exe generates them - it doesn't use the same script for each report.

Any light that can be shed on this would be appreciated.

Thanks in advance,
John

Edit: I can install SSDT on the build machine if it is possible to deploy via command line.

Edit2: I think SSDT command line of /deploy and the configuration, having one configuration per environment solves what I am after. I will post back with my results in case it helps others.

Edited by John Hennesey Thursday, May 28, 2015 1:26 AM

May 27th, 2015 10:53pm

Using SSDT 2012 I tried the following:

Created a configuration called "Dev54" at the solution level, which trickled down into each of the .rptProj projects.
Went into each of the projects and set the target server url, target path, data sources folder for the Dev54 configuration
Deployed to confirm it all is set up correctly
Ran the command : devenv "C:\[path]\[solution.sln]" /deploy "Dev54" from the "c:\program files (x86)\Microsoft Visual Studio 11.0\Common7\IDE" folder and got the below output

Microsoft (R) Microsoft Visual Studio 2012 Version 11.0.61030.0.
Copyright (C) Microsoft Corp. All rights reserved.
------ Build started: Project: Policy, Configuration: Dev54 ------
------ Build started: Project: PolicyCharts, Configuration: Dev54 ------
------ Build started: Project: Claims, Configuration: Dev54 ------
------ Build started: Project: ClaimsCharts, Configuration: Dev54 ------
------ Build started: Project: LossControl, Configuration: Dev54 ------
------ Build started: Project: LossControlCharts, Configuration: Dev54 ------
------ Build started: Project: Underwriting, Configuration: Dev54 ------
------ Build started: Project: UnderwritingCharts, Configuration: Dev54 ------
------ Build started: Project: Financial, Configuration: Dev54 ------
------ Build started: Project: FinancialCharts, Configuration: Dev54 ------
------ Build started: Project: Common, Configuration: Dev54 ------
------ Build started: Project: Portal, Configuration: Dev54 ------
------ Build started: Project: PortalCharts, Configuration: Dev54 ------
------ Deploy started: Project: Policy, Configuration: Dev54 ------

C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE>

But nothing was deployed. Thinking it was something wrong with the Policy project, so I deleted it. Same response on the first project it tried to deploy. So I checked event viewer and found indeed there were some unhandled exceptions:

----------------------------------- First error

Application: devenv.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.InvalidCastException
Stack:
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Configuration.FileProjectHierarchyDeployCfg+DeployProcessHolder.DoDeploy()
at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()

----------------------------------- Second error

Faulting application name: devenv.exe, version: 11.0.61030.0, time stamp: 0x5270a974
Faulting module name: KERNELBASE.dll, version: 6.3.9600.17415, time stamp: 0x54504ade
Exception code: 0xe0434352
Fault offset: 0x00014598
Faulting process id: 0x1348
Faulting application start time: 0x01d09981f0ac9746
Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe
Faulting module path: C:\Windows\SYSTEM32\KERNELBASE.dll
Report Id: 30ad20a4-0575-11e5-82a8-d850e6552c5b
Faulting package full name:
Faulting package-relative application ID:

----------------------------------- First warning (third entry)

Fault bucket 94747177941, type 5
Event Name: CLR20r3
Response: Not available
Cab Id: 0

Problem signature:
P1: devenv.exe
P2: 11.0.61030.0
P3: 5270a974
P4: Microsoft.DataWarehouse.VsIntegration
P5: 11.0.5058.0
P6: 5374012f
P7: 81a
P8: 6a
P9: System.InvalidCastException
P10:

Attached files:
C:\Users\JHennesey\AppData\Local\Temp\WER7097.tmp.WERInternalMetadata.xml
C:\Users\JHennesey\AppData\Local\Temp\WER726D.tmp.appcompat.txt
minidump.mdmp

These files may be available here:
C:\Users\JHennesey\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_devenv.exe_907faa3a9d9c68ff88a164bc93477cd86840befa_fc6a3110_16a673c4

Analysis symbol:
Rechecking for solution: 0
Report Id: 30ad20a4-0575-11e5-82a8-d850e6552c5b
Report Status: 4104
Hashed bucket: c3a04b4d76532658b97c49405121ddf1

---------------------------------------- And lastly the .wer file that was outputted:

Version=1
EventType=CLR20r3
EventTime=130773172601283252
ReportType=2
Consent=1
UploadTime=130773172602233520
ReportIdentifier=30ad20a5-0575-11e5-82a8-d850e6552c5b
IntegratorReportIdentifier=30ad20a4-0575-11e5-82a8-d850e6552c5b
WOW64=1
NsAppName=devenv.exe
Response.BucketId=c3a04b4d76532658b97c49405121ddf1
Response.BucketTable=5
Response.LegacyBucketId=94747177941
Response.type=4
Sig[0].Name=Problem Signature 01
Sig[0].Value=devenv.exe
Sig[1].Name=Problem Signature 02
Sig[1].Value=11.0.61030.0
Sig[2].Name=Problem Signature 03
Sig[2].Value=5270a974
Sig[3].Name=Problem Signature 04
Sig[3].Value=Microsoft.DataWarehouse.VsIntegration
Sig[4].Name=Problem Signature 05
Sig[4].Value=11.0.5058.0
Sig[5].Name=Problem Signature 06
Sig[5].Value=5374012f
Sig[6].Name=Problem Signature 07
Sig[6].Value=81a
Sig[7].Name=Problem Signature 08
Sig[7].Value=6a
Sig[8].Name=Problem Signature 09
Sig[8].Value=System.InvalidCastException
DynamicSig[1].Name=OS Version
DynamicSig[1].Value=6.3.9600.2.0.0.256.4
DynamicSig[2].Name=Locale ID
DynamicSig[2].Value=1033
DynamicSig[22].Name=Additional Information 1
DynamicSig[22].Value=5861
DynamicSig[23].Name=Additional Information 2
DynamicSig[23].Value=5861822e1919d7c014bbb064c64908b2
DynamicSig[24].Name=Additional Information 3
DynamicSig[24].Value=a10f
DynamicSig[25].Name=Additional Information 4
DynamicSig[25].Value=a10ff7d2bb2516fdc753f9c34fc3b069
UI[2]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe
UI[3]=Microsoft Visual Studio 2012 has stopped working
UI[4]=Windows can check online for a solution to the problem.
UI[5]=Check online for a solution and close the program
UI[6]=Check online for a solution later and close the program
UI[7]=Close the program
LoadedModule[0]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe
LoadedModule[1]=C:\Windows\SYSTEM32\ntdll.dll
LoadedModule[2]=C:\Windows\SYSTEM32\KERNEL32.DLL
LoadedModule[3]=C:\Windows\SYSTEM32\KERNELBASE.dll
LoadedModule[4]=C:\Windows\system32\apphelp.dll
LoadedModule[5]=C:\Windows\AppPatch\AcGenral.DLL
LoadedModule[6]=C:\Windows\SYSTEM32\msvcrt.dll
LoadedModule[7]=C:\Windows\SYSTEM32\sechost.dll
LoadedModule[8]=C:\Windows\SYSTEM32\SspiCli.dll
LoadedModule[9]=C:\Windows\SYSTEM32\SHLWAPI.dll
LoadedModule[10]=C:\Windows\SYSTEM32\UxTheme.dll
LoadedModule[11]=C:\Windows\SYSTEM32\USER32.dll
LoadedModule[12]=C:\Windows\SYSTEM32\GDI32.dll
LoadedModule[13]=C:\Windows\SYSTEM32\WINMM.dll
LoadedModule[14]=C:\Windows\SYSTEM32\samcli.dll
LoadedModule[15]=C:\Windows\SYSTEM32\ole32.dll
LoadedModule[16]=C:\Windows\SYSTEM32\OLEAUT32.dll
LoadedModule[17]=C:\Windows\SYSTEM32\MSACM32.dll
LoadedModule[18]=C:\Windows\SYSTEM32\VERSION.dll
LoadedModule[19]=C:\Windows\SYSTEM32\SHELL32.dll
LoadedModule[20]=C:\Windows\SYSTEM32\USERENV.dll
LoadedModule[21]=C:\Windows\SYSTEM32\dwmapi.dll
LoadedModule[22]=C:\Windows\SYSTEM32\urlmon.dll
LoadedModule[23]=C:\Windows\SYSTEM32\ADVAPI32.dll
LoadedModule[24]=C:\Windows\SYSTEM32\WINSPOOL.DRV
LoadedModule[25]=C:\Windows\SYSTEM32\MPR.dll
LoadedModule[26]=C:\Windows\SYSTEM32\RPCRT4.dll
LoadedModule[27]=C:\Windows\SYSTEM32\CRYPTBASE.dll
LoadedModule[28]=C:\Windows\SYSTEM32\combase.dll
LoadedModule[29]=C:\Windows\SYSTEM32\WINMMBASE.dll
LoadedModule[30]=C:\Windows\SYSTEM32\profapi.dll
LoadedModule[31]=C:\Windows\SYSTEM32\iertutil.dll
LoadedModule[32]=C:\Windows\SYSTEM32\WININET.dll
LoadedModule[33]=C:\Windows\SYSTEM32\bcryptPrimitives.dll
LoadedModule[34]=C:\Windows\SYSTEM32\cfgmgr32.dll
LoadedModule[35]=C:\Windows\SYSTEM32\DEVOBJ.dll
LoadedModule[36]=C:\Windows\SYSTEM32\SHCORE.DLL
LoadedModule[37]=C:\Windows\system32\IMM32.DLL
LoadedModule[38]=C:\Windows\SYSTEM32\MSCTF.dll
LoadedModule[39]=C:\Windows\SYSTEM32\SYSFER.DLL
LoadedModule[40]=C:\Windows\SYSTEM32\MSVCR110.dll
LoadedModule[41]=C:\Windows\SYSTEM32\atl110.DLL
LoadedModule[42]=C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.9600.17415_none_dad8722c5bcc2d8f\gdiplus.dll
LoadedModule[43]=C:\Windows\SYSTEM32\MSVCP110.dll
LoadedModule[44]=C:\Windows\SYSTEM32\CRYPT32.dll
LoadedModule[45]=C:\Windows\SYSTEM32\MSASN1.dll
LoadedModule[46]=C:\Windows\SYSTEM32\DPAPI.dll
LoadedModule[47]=C:\Windows\SYSTEM32\kernel.appcore.dll
LoadedModule[48]=C:\Windows\SYSTEM32\mscoree.dll
LoadedModule[49]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll
LoadedModule[50]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\msenv.dll
LoadedModule[51]=C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.9600.17784_none_a9f497a901334c74\COMCTL32.dll
LoadedModule[52]=C:\Windows\SYSTEM32\DWrite.dll
LoadedModule[53]=C:\Windows\SYSTEM32\USP10.dll
LoadedModule[54]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\1033\msenvui.dll
LoadedModule[55]=C:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv\VsLogP.dll
LoadedModule[56]=C:\Windows\SYSTEM32\clbcatq.dll
LoadedModule[57]=C:\Windows\SYSTEM32\CRYPTSP.dll
LoadedModule[58]=C:\Windows\system32\rsaenh.dll
LoadedModule[59]=C:\Windows\SYSTEM32\bcrypt.dll
LoadedModule[60]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\1033\msenvmui.dll
LoadedModule[61]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll
LoadedModule[62]=C:\Windows\SYSTEM32\MSVCR120_CLR0400.dll
LoadedModule[63]=C:\Windows\assembly\NativeImages_v4.0.30319_32\mscorlib\d03a3ddcd6a395878751c5e90fa16915\mscorlib.ni.dll
LoadedModule[64]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System\1a6b5095c4416a37f9ca4cf4436d1311\System.ni.dll
LoadedModule[65]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\clrjit.dll
LoadedModule[66]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Drawing\d91798a9a9fcb450351fe8e49026a69f\System.Drawing.ni.dll
LoadedModule[67]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Windows.Forms\e3a57545efff2de6efdcefb606e35e3e\System.Windows.Forms.ni.dll
LoadedModule[68]=C:\Windows\SYSTEM32\psapi.dll
LoadedModule[69]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Va01fe746#\32d9cf4516f08242115bab36fc138602\Microsoft.VisualStudio.OLE.Interop.ni.dll
LoadedModule[70]=C:\Windows\assembly\NativeImages_v4.0.30319_32\WindowsBase\579202ba970d73dae32cc3a5c68af8e2\WindowsBase.ni.dll
LoadedModule[71]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\WPF\PresentationNative_v0400.dll
LoadedModule[72]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V886c561e#\6e7dacbe0b2ba23a1d1ff703307adf29\Microsoft.VisualStudio.Shell.Interop.ni.dll
LoadedModule[73]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vf4cf6d96#\35fe303efdf7058ac9010aa0ff57ce19\Microsoft.VisualStudio.Shell.Interop.8.0.ni.dll
LoadedModule[74]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vf4cf6997#\3823a795e34d3e8374ff471849de43be\Microsoft.VisualStudio.Shell.Interop.9.0.ni.dll
LoadedModule[75]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V96592816#\2e8794349aae9f41ea30a82ca9c69522\Microsoft.VisualStudio.Shell.Immutable.10.0.ni.dll
LoadedModule[76]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Core\257fa713928375c0ac9b9f24904e988f\System.Core.ni.dll
LoadedModule[77]=C:\Windows\assembly\NativeImages_v4.0.30319_32\PresentationCore\d747b6eed1a44bfd51d76ed6af359316\PresentationCore.ni.dll
LoadedModule[78]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Presentatio5ae0f00f#\1683f0fd402eb83acb756d3d2c1ab331\PresentationFramework.ni.dll
LoadedModule[79]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Xaml\d626184834dde3f4906aff139d4e5bbf\System.Xaml.ni.dll
LoadedModule[80]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\WPF\wpfgfx_v0400.dll
LoadedModule[81]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\vslog.dll
LoadedModule[82]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\1033\VsLogUI.dll
LoadedModule[83]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\sqmapi.dll
LoadedModule[84]=C:\Windows\SYSTEM32\wkscli.dll
LoadedModule[85]=C:\Windows\SYSTEM32\netutils.dll
LoadedModule[86]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V4c263b4e#\141a4aafec865d92e5ea14ea5d437dc4\Microsoft.VisualStudio.TextManager.Interop.ni.dll
LoadedModule[87]=C:\Windows\SYSTEM32\sxs.dll
LoadedModule[88]=C:\Windows\SYSTEM32\msxml6.dll
LoadedModule[89]=C:\Windows\assembly\NativeImages_v4.0.30319_32\EnvDTE\4ea0f8d2ae9890b661c03749b18b9b79\EnvDTE.ni.dll
LoadedModule[90]=C:\Windows\assembly\NativeImages_v4.0.30319_32\EnvDTE80\58df200befb3ee9fe3e5a32b2a2434e6\EnvDTE80.ni.dll
LoadedModule[91]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Sd86e9d35#\34fc2b324b84e1629decfb118b7648f4\Microsoft.SqlServer.Sqm.ni.dll
LoadedModule[92]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\sqmapi.dll
LoadedModule[93]=C:\Windows\SYSTEM32\powrprof.dll
LoadedModule[94]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vc7739fa8#\aa15dc8b86075a2a3d2f3e7592dcc817\Microsoft.VisualStudio.Text.Logic.ni.dll
LoadedModule[95]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V2058f2c6#\ace36b92c7469939841b90d72a6cc4dc\Microsoft.VisualStudio.TextManager.Interop.8.0.ni.dll
LoadedModule[96]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.MSXML\33d58b7ad9f8770eb1a6e2d33f935933\Microsoft.MSXML.ni.dll
LoadedModule[97]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vc03598f6#\21988e560ef844b1527b5faa25b3a3c8\Microsoft.VisualStudio.Text.Data.ni.dll
LoadedModule[98]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V0adf9eae#\e7ba8bc91436b86da5b35fd0cd8da214\Microsoft.VisualStudio.CoreUtility.ni.dll
LoadedModule[99]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Va36ca875#\09dc391a28419be9cccadb16c65694f3\Microsoft.VisualStudio.ComponentModelHost.ni.dll
LoadedModule[100]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V68a56f61#\a6ff5525c0d933a0924c4efd9c051db9\Microsoft.VisualStudio.Text.Internal.ni.dll
LoadedModule[101]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Compba577418#\c9a7382a4f3e988b25ec829e08e118fd\System.ComponentModel.Composition.ni.dll
LoadedModule[102]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vd5d72abf#\764680eba028992fe68376b6216bbfd4\Microsoft.VisualStudio.ExtensionManager.ni.dll
LoadedModule[103]=C:\Windows\SYSTEM32\Secur32.dll
LoadedModule[104]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vd5001c35#\e6aae294c20b1447ceddfd5f99aaf497\Microsoft.VisualStudio.Text.UI.Wpf.ni.dll
LoadedModule[105]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\coloader80.dll
LoadedModule[106]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V246d69f4#\057360115fb0070b6b75ee35ede46daf\Microsoft.VisualStudio.Editor.ni.dll
LoadedModule[107]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vaa2213a5#\30d76bd5b943cd980c8dbcdd0ede25e4\Microsoft.VisualStudio.Diagnostics.Measurement.ni.dll
LoadedModule[108]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V2b722cdf#\382333b841994acbbdbd1a3b08746fcb\Microsoft.VisualStudio.TextManager.Interop.10.0.ni.dll
LoadedModule[109]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.V0ca2bbda#\443830f05b71491a75987fee7f6f2b90\Microsoft.VisualStudio.Text.UI.ni.dll
LoadedModule[110]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Xml\9a349fb029581f4752d2c6cfcfeab816\System.Xml.ni.dll
LoadedModule[111]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Configuration\d9961946cc4b6fb67e19cd2f8ce90a76\System.Configuration.ni.dll
LoadedModule[112]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Rb0aaae87#\1e3b4aa6dee51084618ec56432c81452\Microsoft.ReportingServices.Interfaces.ni.dll
LoadedModule[113]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.S23385f81#\ca6c77f55969ebe3ca701a3339c2ef3f\Microsoft.SqlServer.MgdSqlDumper.ni.dll
LoadedModule[114]=C:\Windows\assembly\GAC_32\Microsoft.SqlServer.MgdSqlDumper\11.0.0.0__89845dcd8080cc91\Microsoft.SqlServer.MgdSqlDumper.dll
LoadedModule[115]=C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.8428_none_d08a11e2442dc25d\MSVCR80.dll
LoadedModule[116]=C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.8428_none_d08a11e2442dc25d\msvcm80.dll
LoadedModule[117]=C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Vb2a02228#\21e73e79f4092368061d5698bceb7478\Microsoft.VisualStudio.Designer.Interfaces.ni.dll
LoadedModule[118]=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\1033\Microsoft.VisualStudioUI.dll
LoadedModule[119]=C:\Windows\SYSTEM32\actxprxy.dll
LoadedModule[120]=C:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv\msenv100p.dll
LoadedModule[121]=C:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv\msenvp.dll
LoadedModule[122]=C:\Program Files (x86)\Common Files\Microsoft Shared\MSEnv\msenv80p.dll
LoadedModule[123]=C:\Windows\assembly\NativeImages_v4.0.30319_32\System.Web.Services\610c409fd2e27159f3f3610b15d83921\System.Web.Services.ni.dll
LoadedModule[124]=C:\Windows\SYSTEM32\rasapi32.dll
LoadedModule[125]=C:\Windows\SYSTEM32\rasman.dll
LoadedModule[126]=C:\Windows\SYSTEM32\WS2_32.dll
LoadedModule[127]=C:\Windows\SYSTEM32\NSI.dll
LoadedModule[128]=C:\Windows\SYSTEM32\rtutils.dll
LoadedModule[129]=C:\Windows\system32\mswsock.dll
LoadedModule[130]=C:\Windows\SYSTEM32\winhttp.dll
LoadedModule[131]=C:\Windows\SYSTEM32\IPHLPAPI.DLL
LoadedModule[132]=C:\Windows\SYSTEM32\WINNSI.DLL
LoadedModule[133]=C:\Windows\SYSTEM32\dhcpcsvc6.DLL
LoadedModule[134]=C:\Windows\SYSTEM32\dhcpcsvc.DLL
LoadedModule[135]=C:\Windows\SYSTEM32\DNSAPI.dll
LoadedModule[136]=C:\Program Files (x86)\Bonjour\mdnsNSP.dll
LoadedModule[137]=C:\Windows\System32\rasadhlp.dll
LoadedModule[138]=C:\Windows\System32\fwpuclnt.dll
LoadedModule[139]=C:\Windows\SYSTEM32\msv1_0.DLL
LoadedModule[140]=C:\Windows\SYSTEM32\cryptdll.dll
LoadedModule[141]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\clrcompression.dll
LoadedModule[142]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\diasymreader.dll
State[0].Key=Transport.DoneStage1
State[0].Value=1
FriendlyEventName=Stopped working
ConsentKey=CLR20r3
AppName=Microsoft Visual Studio 2012
AppPath=C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe
NsPartner=windows
NsGroup=windows8
ApplicationIdentity=6F210DE2C086A07E9BD3AAF924456D99

If you could please pass this along to your contacts I would really appreciate it.

Thank you in advance,
John

Edited by John Hennesey Thursday, May 28, 2015 8:18 PM More information

Free Windows Admin Tool Kit Click here and download it now

May 28th, 2015 8:15pm

Qiuyun Yu -

Any update on this?

Thank you,
John

Edit: I tried again with a brand new project, with only 1 report and 1 data source. It did not error out, but then again it didn't give any output during the deploy, and nothing wound up on the target server. Do you have any update? Has anyone gotten this to work?

Edit #2 : Apparently there is a connect bug out there already on this. :( I wish MS could get this functionality working - I cannot believe it isn't out of the box after this long.

Edited by John Hennesey Wednesday, June 10, 2015 6:07 PM

June 4th, 2015 1:35pm

Hi John,

After some research, from a support perspective this is really beyond what we can do here in the forums. If you cannot determine your answer here or on your own, consider opening a support case with us. Visit this link to see the various support options that are available to better meet your needs: http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone.

Thanks,

Wynn

Free Windows Admin Tool Kit Click here and download it now

June 23rd, 2015 8:41pm

Wynn -

Thank you for the reply. I have been using the forums for probably 15 years, and I can honestly say I have never seen a response from Microsoft like this one. I was at least hoping for "It is possible, please see x, y and z articles", or "we have others who have asked for it, and here are a couple links", etc. Are you able to provide anything like this? The only information I can find are snippets on codeplex, etc. that are 5-10 years old. Lots of people looking for it, but no real solutions. I would hope that MS would have at least considered something by now - SSRS and MsBuild are at the kernel of MS products. :(

Can you offer any other suggestions? Any success stories of people successfully automating report deployment?

Thank you in advance,

John

June 23rd, 2015 9:47pm

This topic is archived. No further replies will be accepted.