General information
Forum:
Microsoft SQL Server
>>>>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.
Ok
I'm having a look at SSIS.
Do you have any idea how I would split my output csv files to give seperate files depending on the data selected.
So lines with a type of AV01 would go in AV01.csv and AV02 would go in AV02.csv
Thanks
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only