Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Export to txt From procedure output
Message
 
 
To
13/09/2007 08:50:09
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01253947
Message ID:
01254080
Views:
23
What type of data source are you using? I can map columns from OLE DB datasource with SP as SQL command to a flat file destination.

>Thanks for your reply, Sergey, you always seem to be able to help. :)
>
>In this case, I did as you indicated in the begining, and the source is linked to the destination, but the fields from the source are not able to be linked to the fileds in the destination. I can even preview the result set from the procedure. It seems that SS05 is unable to see the fields (field names) that come from the procedure to be able to link them to the destination fields. Without this step, you can not save that step in the package. It won't complete (unless, of course, I am doing something wrong). I have only been working with 2005 for a month or so, and am unable to find documentation on this particular implementation.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform