Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files RE: Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files
UMG Developer
SSChampion
Points: 13482
More actions
March 3, 2009 at 9:35 am
#952512
How about a SQLCLR method to execute a DTS or SSIS package on the server instead of using xp_cmdshell and calling DTEXEC.EXE? (Or is there another way to do that in an SP that I have missed?)