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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 call ssis from asp.net sql2008 ,visual studio 2010

Author  Topic 

reemlana
Starting Member

3 Posts

Posted - 2011-09-22 : 01:29:53
After I use ssis to import my excel data into sql server,There I need to do some changes to some fields such as data types,and add extra fields,so I did couple of ssis do to do such a job.
but I want my application to be able to run all these packages ,so the user shouldnt be worried about such job
so what best way to do that
stored procedure or use refrence to what best way to call ssis package through asp.net in sql 2008 ,
i want to use this refrence microsoft sqlserver dts runtime namespace
but i cant find such a refrence i added all dts refrences,
but i still get error they not refrences microsoft sqlserver dts runtime
all what I want to acomplish is have my asp.net ,execute ssis package

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-22 : 04:16:47
see
http://www.codeproject.com/KB/aspnet/SSIS_DOTNET.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -