Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

Need to create an output file from sql query in an SSIS package

Hi experts,
I created a stored proc out of a sql query that generates some results. I need to get the results into an excel file. Which task should I use after the exec sql task to do this?
Thanks!
0
sqlcurious
Asked:
sqlcurious
1 Solution
 
CboudrozCommented:
You need to execute the proc inside a data flow task

read the first post there:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/669e484e-7c79-4271-8ae5-50af2dab0e3a/
0
 
Alpesh PatelAssistant ConsultantCommented:
1. Use Data flow
2. Source as OLEDB source
3. EXCEL Destination
0
 
sqlcuriousAuthor Commented:
thnks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now