Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xp_cmdshell
Message
From
20/05/2011 11:09:39
 
 
To
20/05/2011 10:40:20
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01511214
Message ID:
01511276
Views:
41
>>>>>>>>>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
>>>>
>>>>The beautiful thing about SSIS is you have pretty much complete programmatic control at every step of the process.
>>>>
>>>>Kevin is the authority here ( I'd recommend his Code Magazine Baker's Dozen article in two parts on SSIS ) . The AppDev course is pretty comprehensive ( $99 for all their stuff for a year ) and Pluralsight ( $29 a month ) has SSIS course as well.
>>>>
>>>>If you just need a one-off, just Googling around should yield lots of stuff
>>>>http://www.bimonkey.com/2009/06/the-conditional-split-transformation/
>>>>http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx
>>>
>>>Thanks Charles.
>>>
>>>You watching game of thrones ?.
>>>
>>>I'm reading the books and enjoying them mostly.
>>
>>I am obsessing on GOT and reading through the whole cycle for the second time ( also listened to the whole thing on audiobook ) Very pleased with the way they are doing the TV series. Really sticking to the spirit and atmosphere of the books. This is a very good example of where only TV can tell a story with any scope. The idea of making each of the books a 2 hr hollywood movie was always anathema to me. Glad to see they went this route.
>
>Without plot spoiling I have been told of at least one key event which was changed in the TV series and alters the tone considerably.

OK, I gotta know. Send me a private message.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Reply
Map
View

Click here to load this message in the networking platform