Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
StalinSubash
Starting Member
2 Posts |
 Posted - 2011-06-09 : 03:08:37
|
| Hi,I created a sample SSIS package, import data from csv file and store it into sql server 2008 db.if i execute the package alone it will execute.If call via Visual Studio 2010, i got below error.C# code:--------using System;using System.Collections.Generic;using System.Linq;using System.Text;using Microsoft.SqlServer.Dts.Runtime;using Microsoft.SqlServer.Dts.Runtime.Wrapper;namespace SSISConsoleApps{ class Program { static void Main(string[] args) { Application app = new Application(); Package package = app.LoadPackage(@"D:\Projects\SampleSSIS\SampleSSIS\Package2.dtsx",null); DTSExecResult result = package.Execute(); }}Error:------Cannot implicitly convert type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackage100' to 'Microsoft.SqlServer.Dts.Runtime.Wrapper.Package'. An explicit conversion exists (are you missing a cast?)Please advise me on this.ThanksStalin.M |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
|
|
|
|
|
Error: Calling SSIS Package from VS2010(C#)
