sql server dts: Hello All,

OLE DB Source executed an SP to retrieve data. Trying to send the output to
Raw File.

When editing the raw file task, "This component has no available input
columns".

When trying to save/close the edit window, "There is no selected column to
be written to the file".

Are SP sources incompatible with Raw File task?

--
Thanks.

Hello Mike,

Are you referring to the RAW FILE destination adapter? If you are then the
component does not care from where you get the data. By the time it reaches
the component it is simply data regardless of origin.

On the second tab of the Destinstion adapter is a page where you need to
specify the incoming columns to write out to the file. Have you done that?



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]