Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSIS 2008 Script Task Import Dynamic Data Into Excel

  • 2 October 2012
  • Author: PropellerHead
  • Number of views: 3603
  • 0 Comments

Can someone help get me started to take data from a parameterized stored procedure with variable columns and create a tab for each value in one field using a script task?  I am presuming a script task is the way to go but am open to any other suggestions.  I am using temp tables in the stored procedure and the OLE DB component says it cannot find it although the stored procedure runs just fine otherwise.  I appreciate any ideas anyone may have.

Thanks!

Print
Tags:
Rate this article:
No rating

PropellerHeadPropellerHead

Other posts by PropellerHead

Please login or register to post comments.