SSIS No Column Names in OLEDB Data Source

By -
Have you had this problem before with a stored procedure that has a temporary table?
While I was using a stored procedure as a source for my OLEDB connection, No columns was listed in the source editor.

After some research, I landed at
http://msdn.microsoft.com/en-us/library/ms173839%28v=sql.105%29.aspx


Just add:

SET FMTONLY OFF
exec STOREDPROCEDURE

This will force the parser to return only the metadata to SSIS.

Hope that helps and feel free to share any findings on when do you get this issue.

Comments

Post a Comment

Popular posts from this blog

Open SSRS Linked URLS in a new window

By -
Image
Greetings....as I mentioned before sometimes I use my blog posts as a way to remind myself of the stuff that I need frequently and never keep to memory. I needed to add a link in a new SSRS report and the link has to open in a new browser's window. Just Right click on your report field, select "Text Box Properties", select "Action", click on the "FX" sign to write that special expression. ="javascript:void(window.open('" + Fields!URL.Value + "','_blank'))" Assuming that your URL is dynamic and the column name is "URL" in your dataset SSRS Link in  new Browser's Window Hope that helps...
Read more

SSRS Font Weight expressions

By -
Image
Recently I was tasked to edit an old SSRS report, the report has multiple columns and I need to change the font weight to BOLD based on a specific value. It's so simple but annoying that it needs to be done manually to all the columns that you need the expression to check. which was 25 columns in my case! Steps: Right-click on the column and select "text Box Properties" Select "Font" from the left menu Next to BOLD click on the expression menu In the expression screen; write the expression based on your column and the condition. =IIF(Fields!JB.Value > 0, "Bold","Normal") So here I'm setting the Property "FontWeight" of the textbox to be "Bold" when the value is greater than 0, otherwise, you're setting it to "Normal". hope that helps!
Read more