>>>HI
>>>
>>>I'm working on some old sql thats using xp_cmdshell to query some data and then output results to series of csv files using bcp.
>>>
>>>Is SSIS a better way to do this sort of thing.
>>>
>>>Thanks
>>>
>>>Nick
>>
>>Yes, SSIS is a better way.
>
>You're being like Sheldon I see.
>
>Why is it the best way ?
Because opening xp_cmdshell presents security risk. It is disabled by default. In addition, SSIS offers error logging.
If it's not broken, fix it until it is.
My Blog