MVC & SSIS Package

Question

Hi I have Create ssis package and it will be executed through MVC. it is working fine in my local machine. after i publish in IIS server it is not executing. I got the error massage like 'Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap Version=12.0.0.0 Culture=neutral PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.' In IIS server machine SSIS in not installed. Plese help me..... Thanks & Regards Arasu s

Nitin Sontakke · Answer

You will obviously need something to run SSIS package on IIS Server right? If you give me a file with AutoCAD diagram how do you expect me to open it without AutoCAD? It's the same thing. Anyway there is a small run time available for executing SSIS packages which is called DTSRun.exe (or something similar) which needs to be installed. Of course if your SSIS package has any other dependencies those will have be looked into as well.

arasu selvaraj · Answer

Hi Nitin Thanks for replay. Now i have tried different way. because in IIS server i am not able to install BIDS. So i have tried Store procedure to excute the SSIS package. my ssis package and excel files are in my DB server. after i execute the procedure i am getting the bellow error message. Source: Package Connection manager Excel Connection Manager Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS as no OLE DB provider is available. I have change the Rund64bitruntime to false. now also i am getting same error. any deployment i have to do. Please help me. Thanks & Regards Arasu s.

Nitin Sontakke · Answer

Hopefully both the IIS and SQL Server are on same domain if so just add this account to the sql server (Windows login) and give appropriate permissions to this account to access the database.

arasu selvaraj · Answer

Hi Nitin Thanks for replay. After install ssis in my iis server  i am getting the bellow issue. kindly help me to solve this issue. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: Microsoft OLE DB Provider for SQL Server Hresult: 0x80040E4D Description: Login failed for user 'OMH\BLRTESTIIS$'.. Thanks & Regards Arasu s