>>We need to produce data files for transfer to another system. i.e. Run a stored proc and produce a pipe delimited text file.
>>
>>What we're doing at the moment is running everything through a .Net app that runs the stored proc and romps through the resulting table to build the text file. This works, but we'd like to do some type of SSRS/SSIS package so these runs can be scheduled and automated. Is this possible, and if so - would someone be so kind as to point me towards some documentation/examples/etc.?
>>
>>How do y'all do this?
>>
>>Thanks
>
>Dorris, when I taught SSIS, I created some videos to talk people through examples:
>
>
http://kevin_s_goff.typepad.com/setfocusadditionalbi/ssis-1/>
>Video #2 (Database Maintenance tasks) shows how to schedule an SSIS package in Agent
>
>Other videos in the list show different functionality in SSIS. The videos are a bit dated (most are 3-5 years old) but are still relevant.
>
>Let me know if that helps...
PMFYI, what tool(s) did you use to create the videos?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham