SQL Server 2005, VB.Net 2005 Windows Application
at present i have a VB.Net program that creates CSV files, its opening the datareader and writing to the CSV File. the problem is when data size increases( in test environment data is about 220000 records going into 3 files, each file about 80K records) its taking time ( in test environment its varying between 30-45 minutes). so we searched for an alternative solution and found SSIS packages is faster than existing program. we created a test package and in the same environment its creating a file with 80K records in about 20-30 seconds(its really seconds). the only difference is the package is executed on the server itself. Now the problem is we have to execute the package from our vb application.
I know about commond line utility dtexec . To execute it from a stored procedure i have to use xp_cmdshell extended stored procedure. the main problem is in SQL server 2005 by default xp_cmdshell is disabled. and as per the enterprise security policy i cannot change it to enabled.
Now i am looking for other alternatives how can i execute a SSIS package using T/SQL.