Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xp_cmdshell
Message
From
20/05/2011 09:48:18
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01511214
Message ID:
01511241
Views:
38
>>>>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
Map
View

Click here to load this message in the networking platform