RE: Stored Procedures in Integration Services

Hello,

Thank you for your post in MSDN newsgroup!

If I understand the issue correctly, you use a OLE DB source to execute
Stored Procedure from a connection manager, and you want to output the
result to a CSV file. If I'm off-base, please let me know.

Based on my test, you could use Flat file destination and connect the OLE
DB source to the flat file destination. You could create a file connection
manager from Flat file destination:


1. Right click the Flat file destination->Edit->connectioin Manager, click
New, and selet "Delimited"
2. Click Browse, and select, type the file name, and select CSV as file
type.
3. On Mapping tab, you shall be able to see the mappings you want.

If anything is unclear, or if you have any questions on above steps, please
let me know. I look forward to your update.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.


.

Loading