Have been perusing and following instructional exercises on Microsoft Business Intelligence. Furthermore, I might want to illuminate a few things. Thus, as I have perused and rehearsed, there is no in fact assemble process like that of 'expert' or 'msbuild' sort of in MSBI. I am more enthusiasm on the utilities viz: dtutil.exe and the dtexec.exe; with the goal that I may ideally computerize the procedure of arrangement. A few inquiries:
Arrangement here is more sort of move the document *.dtsx on the objective server/record framework/store? Things being what they are, my assemble coordination server, will checkout the records from the form control and execute the dtutil.exe to move (otherwise known as convey, here) to the objective server?
What improvement does this move with dtutil.exe makes with only a manual reorder?
On the off chance that #1 is correct, does it mean I need to introduce the SQL server/SSDT on my construct server, to get the dtutils.exe OR simply duplicating the executable from a hub which have the .exe will be adequate?
For the execution of the bundles, (that were conveyed utilizing the dtutil.exe) would i be able to do it through my construct server on a remote server where the bundle were sent?
Thanks and Regards,