Skip to content

zahid's BI blog

a showcase of my experience in technologies like SQL, SSAS, ETLs, Azure, Power BI, DAX etc..

  • Home
  • About..

Tag: Cursor

Cursor Using Foreach Ado Enumerator in SSIS

June 21, 2011

Recently, I have been trying to make a cursor using SSIS components and came up with this idea. The trick is explained below: Let’s say, we have a record set and we need to loop through the records to concatenate/append one after another in a sequential manner. For example, you have 6 records: A B … More Cursor Using Foreach Ado Enumerator in SSIS

9 Comments Cursor Using Foreach Ado Enumerator in SSIS

Blog Stats

  • 217,154 hits

Recent Posts

  • Oracle Wallet based connection with Power BI
  • Sync Azure Analysis Service Replicas with Azure Automation
  • Analysis Service – current context is read-only
  • MongoDB – where to start
  • Cascading or parent-child slicer issue in Power BI

Top Posts & Pages

  • Dynamic Column Mapping in SSIS : Part 1
  • Cascading or parent-child slicer issue in Power BI
  • MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
  • Logical OR Condition in EvalExpression of a For Loop Container

Categories

  • Azure
  • Data Quality Service (DQS)
  • MDS (SQL Server Master Data Service)
  • MDX, SSAS (Analysis Service), Cube
  • Microstrategy, MSTR
  • MongoDB, NoSQL
  • MS Visual Studio, C#.NET
  • Power BI, DAX
  • Spark, Python
  • SQA, Testing
  • SQL, Database
  • SSIS (SQL Server Integration Service)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 23 other followers

Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • zahid's BI blog
    • Already have a WordPress.com account? Log in now.
    • zahid's BI blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar