How to create an Assembly from a dll?

Good afternoon.

Created an integration package, which processit CC Debugging in VS poose successfully after deployment launched it to run directly on the Core (catalog the Integration Services Catalog). Execution svalilos and gave error that not found file Microsofr.AnalysisServices.AdomdClient UI version 13.
Got to watch win+r -> assembly -> execute. Indeed, the Assembly has only 12 and 11 version. Okay, install MS SQL 2017.6 - did not help, the build has not appeared. Downloaded library 13.0, but how do the build - XS. I think to demolish Windu already...
Maybe someone knows how to overcome ?
June 5th 19 at 21:10
1 answer
June 5th 19 at 21:12
Solution
There are primitive, oak decision on vbs:

Dim dsoServer
Dim dsoDB
Dim dsoCube
set dsoServer = CreateObject("DSO.Server")
dsoServer.Connect the "name or address of server"
Set dsoDB = dsoServer.MDStores.Item("name")
Set dsoCube = dsoDB.MDStores("cube name")
dsoCube.Process 1
dsoServer.CloseServer


well, all this kicking, like so "C:\WINDOWS\SysWOW64\wscript.exe Cut to the vbs script" for example from the regular sheduler windows
The problem is that this solution is not very good for me. I have a job two steps, one T-SQL, which updates the data in the table, and the second time as a package. It is necessary that he waited for when the first Shang will is executed. Another caveat is that each day the selection changes, in fact the table contains exactly the data for the last three months (data pestano need to count, because it remains, to upgrade to for a small period of the table will not work, because the previous periods will show incorrect values), hence the script as the command in full processing I can't run because he swears that today is not the yesterday. - Casimir_Gibs commented on June 5th 19 at 21:15
well sql is also quite so the batch file works out - i.e. everything in the batch file to collect.
vbs is just full process of the cube

but with integration and dts packages Microsoft like all the incompatible versions from 2000 was produced by the matter... for all their prettiness is so unstable structure that if it is possible then it is better to avoid... - delta89 commented on June 5th 19 at 21:18
most annoying that my colleagues all work, they have this package out of the box direct. I was lucky as always ))). Thanks for the help. - Casimir_Gibs commented on June 5th 19 at 21:21
and the finished Assembly direct work without problems on different versions of the axes and not scream for the missing library? ) - delta89 commented on June 5th 19 at 21:24
Yes , at least all who have asked everything works fine ))). - Casimir_Gibs commented on June 5th 19 at 21:27

Find more questions by tags SQL ServerWindowsVisual Studio