Hi All, I have SSIS package to import datafrom Excel sheet to SQL temp table and then am running SQL procedure to distribute the data. Kindly, advise if there is any technique to create simple application in C#.NET or VB.NET that tacks the file, run the package and then run the query. Regards,

Can't you all do that in SSIS? What's the reason for the .Net application (which is possible)? Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Hi, 1.Create a Package which Extracts Data from Excel File and Loads it into SQL table. 2.Add a Execute SQL task in the Package . 3.Deploy the package in SQL MSDB Db and Create a Batch file to Run the Package using CMD Command. http://msdn.microsoft.com/en-us/library/ms162820.aspx http://msdn.microsoft.com/en-us/library/ms162810.aspx [Dtexec using xp_cmd] 4.In your C#.NET or Vb.Net Application Call this Batch file behind the Scene. Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

Hi, Step 1 & 2 done I'll work on 3 & 4. Thanks :)

I want to import the daily excel sheet (from another department) automatically once its available in the destination. I don't wont to check every time .

Hi, 1.Create a Package which Extracts Data from Excel File and Loads it into SQL table. 2.Add a Execute SQL task in the Package . 3.Deploy the package in SQL MSDB Db and Create a Batch file to Run the Package using CMD Command. http://msdn.microsoft.com/en-us/library/ms162820.aspx 4.In your C#.NET or Vb.Net Application Call this Batch file behind the Scene.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/