MVC & SSIS Package

arasu selvaraj

10y1.7k

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Accepted 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 selvaraj10y ago
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 Sontakke10y ago
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 selvaraj10y ago
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