How to execute DTS package without storing it in local [modified]
-
Hi Right now i am stroing dts package in local and executing it. The code what i have written is Dataset ds=new Dataset(); Package package=GeneratePackage(); //Generate package is a my function Application app=new Application(); app.SavetoXML("path",package,null); DtsConnection dtsCon=new DtsConnection(); dtsCon.ConnectionString=package.GetPackagePath(); dtsCon.Open(); DtsCommand dtsComm=new DtsCommand(dtsCon); dtsComm.CommandText="DataReaderDest"; IDataReader reader=dtsComm.ExecuteReader(CommandBehaviour.Default); ds.Load(reader,LoadOption.OverwriteChanges,reader.GetScehmaTable().TableName); return ds; It is working fine. I would like to execute the package without storing it in local using dtscommand. Can anybody help me please. kesavan -- modified at 3:20 Thursday 24th May, 2007