This Video Tutorial illustrates how to use SMO enumerator to loop through linked servers. SMO stands for SQL Server Management Objects, and using SMO provides ability to loop through list of metadata objects of SQL Server database or instance. This enumerator can be used for looping through jobs, linked servers, data files of database, and Read more about Foreach Loop : SMO Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial illustrates how to use ADO.NET Schema Rowset enumerator to loop through metadata information of a data source. ADO.NET Schema Rowset provides ability to loop through list of metadata and schema provided from a data source. For example when data source is SQL Server, the metadata will be fetched from INFORMATION SCHEMA views. Read more about Foreach Loop : ADO.NET Schema Rowset Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial illustrates how to use From Variable enumerator to loop through an array list. From Variable provides ability to loop through an array that filled from a script task. Collection structures such as Array and ArrayList can be loaded into an Object type variable in the SSIS package, and then Foreach Loop with Read more about Foreach Loop : From Variable Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial illustrates how to use Nodelist enumerator to loop through an XML content with Foreach Loop structure. Nodelist uses XPath query language for interating through nodes, elements, attributes of an xml content, that might come from file, variable, or static string. In this sample we call a web service to select name of Read more about Foreach Loop : NodeList Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial starts with an introduction to Contianers in SSIS 2012, then it explains different kind of enumerators in foreach loop contianer. Finally this video will focus on File Enumerator, and shows an example of loading multiple CSV files into a destination table. In the example you will learn how to implement a loop Read more about Foreach Loop Container : File Enumerator – SSIS 2012 Tutorial Videos[…]
This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error. Reason: There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups. for example you might find some membership entries with GUID listed Read more about SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.[…]
I am delighted to say that I will speak at this year’s Pass Summit 2013 in NC Charlotte. Session that I will speak on it is: SSIS Package Failed in Production? Here’s How to Troubleshoot This will be my first attendance in Pass Summit and I am looking forward to see many of you, and Read more about I am speaking at Pass Summit 2013[…]
Last week I’ve talked with Greg Low from SQL Down Under, and Greg published the podcast talk in his website. I really appreciate Greg’s idea an hard work on podcast shows series on his website. I enjoyed when I read podcasts from many SQL Server MVPs about their area of expertise. I strongly recommend to Read more about SQL Down Under Pod Cast[…]
In a multi environment system which you might have Development, UAT and Production for your master data services, the requirement for transfer MDS models across different master data services will be sensible. sometimes you just need to transfer model structure (metadata) from one server to another, but in some situations you will need to have a Read more about MDS: Deploy Master Data Services Model with Data From One Server to Another[…]
Thank you all for attending at my presentation in TechDays 2013 Hong Kong at evening of 3rd day of conference. here you can find presentation file of my speaking session about Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Title: Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Description: Read more about Presentation files for Hong Kong TechDays 2013 : Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012[…]