You’re offline. This is a read only version of the page.
335
Hello
i am getting this error "To run a SSIS package outside of SQL Server Data Tools you must install Dynamics CRM Source of Integration Services or higher.\r\n" when i am excuting SSIS Package(package for data insert from crm to sql db) from .net C# code
here is my code..
using DTS = Microsoft.SqlServer.Dts.Runtime;
public class Call_SSIS_Package
{
public Call_SSIS_Package()
{
// Variables
DTS.Package dtsPackage = null;
DTS.Application dtsApplication = null;
dtsApplication = new DTS.Application();
//Load package by specifying SSIS package file path
dtsPackage = dtsApplication.LoadPackage(@"D:\Yash\All SSIS Package\ThriveQaQuotes(Thrive-to-sql)\ThriveQaQuotes(Thrive-to-sql)\Package.dtsx", null);
DTS.DTSExecResult packageResult = dtsPackage.Execute();
if (packageResult == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
{
string err = "";
foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in dtsPackage.Errors)
{
string error = local_DtsError.Description.ToString();
err = err + error;
}
}
if (packageResult == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success)
{
string message = "Package Executed Successfully....";
}
}
}
Thanks,Regards.
*This post is locked for comments
Well you dont seem to have installed instance of Integration Services on the machine. You need to install it before executing this code via C#.
Download and install: docs.microsoft.com/.../install-integration-services
hy pranav,i have added these Microsoft.Xrm.Sdk.dll,Microsoft.Crm.Sdk.Proxy.dll and also files but i am getting same.
github.com/.../download-dynamics-365-sdk-v9.md
For CRM Online.
Hy Pranav,yes i install SQL Server Data Tools - Business Intelligence for Visual Studio ,where from i get CRM SDK??
Did you install SQL Server Data Tools - Business Intelligence for Visual Studio and CRM SDK?
Check and confirm.
Hope this helps,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (