There are no fields in the file stored procedure

United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote.

Hi, I tried to find some information about this, but surprisingly can't seem to find anything. Clearly, I am missing something here. Monday, September 17, PM. Anthony Martin wrote: -create a data flow task -put the stored procedure as your oledb source and connect it to a flat file destination. Thanks for the help. It shouldn't return any rows, but it needs to be there so SSIS can read the metadata.

Tuesday, September 18, AM. Hi, This is exactly what I tried at first before my original post. When the statement runs, the fields will refresh, and your matrix will be populated. ChadB ChadB 71 1 1 silver badge 1 1 bronze badge.

Add a comment. Create a new Data Source. Create a new DataSet. Donot click on refresh Field. It works. Bhushan Mahajan Bhushan Mahajan 11 1 1 silver badge 6 6 bronze badges.

Phelzier Phelzier 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked 2. Related Hot Network Questions. Question feed. Stats Member Rate me:. Please Sign up or sign in to vote. Using stored procedure type for binding data to dataset in SSRS or adding entity to Entity data model. Solution Not many things to do to solve this problem. Copy Code. Member Software Developer Senior self employed.

This member doesn't quite have enough reputation to be able to display their biography and homepage. Go to top. Layout: fixed fluid.