Skip to content

Zahid's blog on Data Engineering and BI

A showcase of my experience in technologies like SQL, SSIS, SSAS, ETL, Azure, Power BI, DAX etc..

  • Home
  • About..

Tag: String parse

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

  • 227,037 hits

Recent Posts

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

Top Posts & Pages

  • MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
  • Cascading or parent-child slicer issue in Power BI
  • Find out anagram using SQL
  • Sync Azure Analysis Service Replicas with Azure Automation
  • How to run MDX/Create local cubes from SSIS

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 subscribers
Blog at WordPress.com.
  • Follow Following
    • Zahid's blog on Data Engineering and BI
    • Already have a WordPress.com account? Log in now.
    • Zahid's blog on Data Engineering and BI
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar