You can decide whether to add a page to the list of exclusions:
If you are not sure if the website you would like to visit is secure, you can verify it here. Enter the website address of the page and see parts of its content and the thumbnail images on this site. None (if any) dangerous scripts on the referenced page will be executed. Additionally, if the selected site contains subpages, you can verify it (review) in batches containing 5 pages.
site address:
www.itdeveloperzone.com redirected to: www.itdeveloperzone.com
site title: IT Developer Zone-Asp.Net,C#,JQuery,SQL,SSIS,SSRS
Our opinion (on Thursday 28 March 2024 23:15:13 GMT):
- no comments
After content analysis of this website we propose the following hashtags:
Meta tags: description=Blog on Asp.Net,C#,JQuery,SQL, SSIS,SSRS,Code,Interview Questions; keywords=ASP.Net,C#,SQL,SSIS,SSRS,json,class,split,funtion,string; Author=Sandeep Mittal;
Text of the page (most frequently used words): the (103), data (74), and (61), #column (44), file (43), sql (40), #flat (38), #server (37), #ssis (36), #product (34), 2016 (32), #name (29), #split (28), #click (27), add (27), step (26), flow (26), will (25), json (25), with (24), transformation (23), destination (22), derived (21), table (21), response (20), editor (20), string (19), example (19), have (19), source (18), new (18), conditional (18), open (18), package (17), products (16), task (16), ole (16), for (16), price (15), this (15), connection (15), are (15), select (14), columns (14), ssrs (14), null (14), create (14), you (14), public (13), tab (13), configure (13), let (13), image_url (13), card (12), credit (12), below (12), tutorials (12), function (12), aggregate (12), from (12), manager (12), expression (12), net (12), used (12), database (11), using (11), run (11), double (11), window (11), questions (11), format (10), list (10), project (10), value (10), now (10), type (10), interview (10), console (10), set (10), class (9), bank (9), connect (9), generate (9), would (9), get (9), march (9), images (8), prod1 (8), like (8), tools (8), which (8), jpg (8), classes (8), created (8), studio (8), string_split (8), 200 (8), writeline (8), values (7), into (7), where (7), can (7), two (7), delimiter (7), use (7), delimited (7), sbi (7), basis (6), sandeep (6), already (6), mittal (6), switch (6), conversion (6), details (6), first (6), path (6), shared (6), creditcarddetails (6), july (6), management (6), dbo (6), jobject (6), selected (5), prod (5), not (5), october (5), import (5), jquery (5), that (5), 2012 (5), salary (5), close (5), november (5), map (5), output (5), condition (5), our (5), one (5), 100 (5), varchar (5), browse (5), amount (5), asp (5), httpstatus (5), static (5), status (5), mar (4), transactiondate (4), any (4), c00000003 (4), check (4), sbi000000002 (4), c00000004 (4), can000000001 (4), sbi000000001 (4), c00000002 (4), insert (4), customerid (4), prod2 (4), april (4), here (4), january (4), december (4), input (4), built (4), post (4), tutorial (4), multiple (4), done (4), tansactiontype (4), c00000001 (4), numeric (4), int (4), tostring (4), different (4), canara (4), execute (4), display (4), creditcardno (4), zone (3), steps (3), prerequisites (3), names (3), developer (3), more (3), drop (3), control (3), divided (3), about (3), char (3), foreach (3), identify (3), case (3), empsalary (3), previous (3), part (3), sum (3), jtoken (3), what (3), report (3), fetch (3), min (3), max (3), parameters (3), blog (3), posts (3), variables (3), return (3), res (3), jsonconvert (3), deserializeobject (3), functions (3), each (3), 2017 (3), left (3), june (3), take (3), errors (3), how (3), merge (3), method (3), creating (3), answers (3), errormessage (3), comma (3), existing (3), script (3), exported (3), sbi000000004 (2), similar (2), online (2), 1000 (2), datetime (2), primary (2), above (2), characters (2), 2500 (2), same (2), 2800 (2), generated (2), sbi000000003 (2), rows (2), view (2), assume (2), 1485 (2), 2528 (2), applying (2), generator (2), compatible (2), conditions (2), make (2), length (2), them (2), derivied (2), between (2), scale (2), creditcard (2), optionally (2), toolbox (2), 3000 (2), can000000002 (2), node (2), c00000005 (2), precision (2), sub (2), mapping (2), three (2), windows (2), mapped (2), drag (2), parent (2), time (2), detail (2), visual (2), foundation (2), 3rd (2), labels (2), earlier (2), 2008 (2), popular (2), may (2), february (2), getresponse (2), learn (2), etc (2), stores (2), team (2), some (2), separator (2), character (2), home (2), apply (2), cross (2), sharing (2), based (2), datatables (2), there (2), need (2), snapshot (2), means (2), processing (2), single (2), department (2), msbi (2), successfully (2), find (2), depending (2), preview (2), pipe (2), void (2), main (2), args (2), getproductdetails (2), image (2), url (2), files (2), exercised (2), read (2), articles (2), dynamic (2), your (2), start (2), export (2), skip (2), automatically (2), option, mumeric, write, custom, variable, either, non, replace, alias, able, oct, look, onion, potato, all, carrot, syntax, pass, viewer, connector, ouptut, code, val2, val3, decimal, float, enable, brinjal, right, orange, productid, colon, semicolon, val, val1, union, against, grapes, tool, introduced, valued, jul, structure, framework, prerequisite, nuget, microsoft, result, ilist, however, valid, way, high, performance, install, var, parse, purpose, tabular, scenario, takes, banana, apple, declare, clause, needs, stored, another, has, returns, version, form, refer, defined, user, change, own, versions, match, must, hierarchy, copyright, exporting, august, archive, 2015, 2014, 2013, september, 2011, subscribe, 2010, javascript, 2005, intreview, follow, atom, executed, otherwise, box, tick, bar, vertical, mappings, employee, older, then, aggregated, calculate, perform, employees, avg, contactmeasap, followers, multidimensional, row, gooyaabi, instance, consid, points, certain, bloggertheme9, templates, policy, reference, privacy, contact, blogger, powered, distributed, designed, future, copy, relational, application, building, yes, except, other, support, remot, client, freezed, reports, processes, mode, local, offered, modes, without, browser, instead, splitting, packages, frequently, important, very, covert, conditionalsplit, accordingly, sources, banks, identifying, define, destinations, respectively, selection, down, various, but, estination, types, configuring, adding, operators, combination, contains, incompatible, such, require, life, real, converts, place, cases, default, deptwisesalary, 25000, 13000, emp006, 30000, emp005, 20000, emp004, emp003, 23000, 40000, emp002, 50000, emp001, deptid, empid, wise, emp007, emp008, auto, looks, performed, repeat, paths, imported, execution, clearly, stage, 17000, separately, transaction, out, 2021, than, divide, article, category,
Text of the page (random words):
rod1 price 200 image_url images prod2 jpg errors errormessage null now let s generate classes using one of the tools online json c class generator tool we get below classes for our above json response public class product public string id get set public string name get set public string price get set public string image_url get set public class response public int status get set public int httpstatus get set public ilist product gt products get set public class example public response response get set now we have classes mapped with json response now use below code to map the data from json response to classes static void main string args list product products new list product example res new example res getresponse foreach product p in res response products console writeline string format product id 0 p id console writeline string format product name 0 p name console writeline string format product price 0 p price console writeline string format product image url 0 n p image_url console read public static example getresponse string json response status 1 httpstatus 200 products id 1 name product 1 price 100 image_url images prod1 jpg id 2 name prod1 price 200 image_url images prod2 jpg return jsonconvert deserializeobject example json ouptut example 2 using jobject jtoken classes now let s assume we have below json response where parent node for the product data is dynamic which is productid json response response status 1 httpstatus 200 products 1 id 1 name product 1 price 100 image_url images prod1 jpg 2 id 2 name prod1 price 200 image_url images prod2 jpg errors errormessage null in this case we would use jobject jtoken to fetch the product data as we would not able to generate the static classes for this scenario as the parent node has dynamic values which would change on run time static void main string args list product products new list product products getproductdetails foreach product p in products console writeline string format product id 0 p id console writeline string format product name 0 p name console writeline string format product price 0 p price console writeline string format product image url 0 n p image_url console read public static list product getproductdetails list product products new list product product product null string json response status 1 httpstatus 200 products 1 id 1 name product 1 price 100 image_url images prod1 jpg 2 id 2 name prod1 price 200 image_url images prod2 jpg errors errormessage null jobject data jobject parse json jobject products jobject data response products foreach var x in products jtoken prod x value product new product product id prod id tostring product name prod name tostring product price prod price tostring product image_url prod image_url tostring products add product return products output mar 30 2016 ssis tutorials derived column transformation in ssis sandeep mittal march 30 2016 derived column transformation in ssis is used to generate a new column by applying expression on input columns an expression contains any combination of functions variables operators and input columns in one of our previous tutorial conditional split in ssis we used an expression in condition where we identify the bank on the basis of first three characters of credit card column in this post we would use the same table and will generate a derived column bank by applying condition and expression on credit card column to identify the bank prerequisites sql server with ssis sql server data tools sql server management studio if you already have exercised any of the articles from this blog import flat file to sql server with ssis conditional split in ssis you would already have project ssis tutorials and credit card details table in your database you can skip first 2 steps and start with 3rd step 1 create credit card details table in sql server database run sql server management studio connect to database and run below script to create credit card detail table create table dbo creditcarddetails customerid varchar 50 null creditcardno varchar 50 null tansactiontype char 2 null transactiondate datetime null amount numeric 18 2 null on primary go insert dbo creditcarddetails customerid creditcardno tansactiontype transactiondate amount values c00000001 sbi000000001 dr 01 01 2016 2500 00 c00000002 can000000001 dr 01 01 2016 2800 00 c00000001 sbi000000001 cr 02 01 2016 25 00 c00000003 sbi000000002 dr 02 01 2016 1485 00 c00000004 sbi000000003 dr 03 01 2016 2528 45 c00000002 can000000001 cr 04 01 2016 14 00 c00000003 sbi000000002 cr 04 01 2016 37 13 c00000004 sbi000000004 dr 05 01 2016 1000 00 c00000005 can000000002 dr 05 01 2016 3000 20 step 2 run sql server data tools create a new project and add a shared data connection manager step 3 add new package to the project name the package derived column step 4 add data flow task to control flow tab double click data flow task to switch to data flow task tab step 5 add and configure ole db source drag and drop ole db source from ssis toolbox to data flow task double click ole db source will open ole db source editor window select the shared data connection if not selected we created in step 2 select table creditcarddetails step 6 add and configure derived column add derived column to data flow task connect ole db source to derived column double click derived column to open conditional split transformation editor conditional split transformation editor is divided into 3 sub windows columns variables and parameters are used in expression to generate derived column s in built functions are optionally used in expression like we are using left function in the expression derived column here we configure derived column s derived column name name of the derived column that would be generate it is similar to alias column in t sql derived column you have two option here either generate column as a new column or replace the existing one expression here we write custom expression using columns variable and in built function to generate column data type data type of the derivied column that would be generated length display length of the derivied column for non mumeric columns precision display precision if the data type of column is numeric scale display scale if the columns is decimal float let s add a derived column bank name a s a new column where we will identify bank on the basis of first three characters of credit card column step 7 at this step we are done with adding and configuring derived column now instead of exporting data to some destination we can preview the data with derived column on the run time add conditional split to the data flow task connect derived column to conditional split right click connector between derived column and conditional split and click enable data viewer we are done with creating the package let s execute the package preview the data look at the output the derived column bank name is generated in data view window mar 22 2016 ssis tutorials data conversion transformation in ssis sandeep mittal march 22 2016 data conversion transformation in ssis is used to covert the data type of a column it is very important transformation and is frequently used in packages for example in a package we import the data from various sources and the columns have x data type but the data type of destination columns have y data type in such cases we need data conversion transformation we place data conversion transformation between source and destination so that it converts the data type of source columns to make it compatible with destination columns let s take a real life example where we will import a flat file to sql server and we would require data conversion transformation import flat file to sql server using ssis in the above example there are two columns data and amount which have incompatible data types and we have used data conversion transformation to make them compatible mar 10 2016 ssis tutorials conditional split transformation in ssis sandeep mittal march 10 2016 in this article you will learn about conditional split transformation in ssis with an example conditional split is used to divide the flow of data to more than one destination depending on the condition s example we have a table in sql server database which stores credit card details and we will fetch the data and on the basis of credit card no will find out the the bank of the transaction and will export the credit card details into flat files for each bank separately prerequisites sql server with ssis sql server data tools sql server management studio if you have already exercised any of the below articles from this blog import flat file to sql server with ssis derived column transformation in ssis you would already have project ssis tutorials and credit card details table in your database you can skip first 2 steps and start with 3rd step 1 create credit card details table in sql server database run sql server management studio connect to database and run below script to create credit card detail table create table dbo creditcarddetails customerid varchar 50 null creditcardno varchar 50 null tansactiontype char 2 null transactiondate datetime null amount numeric 18 2 null on primary go insert dbo creditcarddetails customerid creditcardno tansactiontype transactiondate amount values c00000001 sbi000000001 dr 01 01 2016 2500 00 c00000002 can000000001 dr 01 01 2016 2800 00 c00000001 sbi000000001 cr 02 01 2016 25 00 c00000003 sbi000000002 dr 02 01 2016 1485 00 c00000004 sbi000000003 dr 03 01 2016 2528 45 c00000002 can000000001 cr 04 01 2016 14 00 c00000003 sbi000000002 cr 04 01 2016 37 13 c00000004 sbi000000004 dr 05 01 2016 1000 00 c00000005 can000000002 dr 05 01 2016 3000 20 step 2 run sql server data tools create a new project and add a shared data connection manager if already created in previous tutorial s open the existing project ssis tutorials step 3 add new package to the project name the package conditionalsplit step 4 add data flow task to control flow tab double click data flow task to switch to data flow task tab step 5 add and configure ole db source drag and drop ole db source from ssis toolbox to data flow task double click ole db source will open ole db source editor window select the shared data connection if not selected we created in step 2 select table creditcarddetails step 6 add and configure conditional split add conditional split to data flow task connect ole db source to conditional split double click conditional split to open conditional split transformation editor conditional split transformation editor is divided into 3 sub windows columns variables and parameters are used in expression to split the flow of data here we are using creditcard column in our example in built functions are optionally used in expression like we are using left function in the expression condition s that define how to split the flow of data in our example we have two conditions where using left function on creditcard column we are identifying different banks and accordingly splitting the flow of data in different path you can add more conditions to split more data flow step 7 add and configure flat file destination s add two flat file destinations and name them sbi canara bank respectively connect conditional split to sbi flat file destination this will open input output selection window select sbi in the output drop down list and click ok double click sbi flat file destination to open flat file destination editor click new will open flat file format window delimited will be selected by default click ok will close the flat file window and will open flat file connection manager editor window click browse to set the destination path of the flat file set the file name as sbi and click open click ok to close the flat file connection manager editor window on flat file destination editor switch to mapping tab input column will be auto mapped with d estination column in case not configure mapping like below and click ok repeat the steps for canara flat file destination similar to what we have performed for sbi flat file destination select canara as output and file name in flat file manager editor flat file connection manager will be selected which we created for sbi flat file destination click on new to create new flat file connection for canara flat file destination at this stage we are done with creating the package package looks like below now let s execute the package package execute successfully you can clearly view in the execution flow 9 rows imported from the table and conditional split transformation divided the flow of data to 6 and 3 rows on different paths depending on condition now let s browse the path and check the files and data mar 5 2016 ssis tutorials aggregate transformation in ssis sandeep mittal march 05 2016 in this tutorial you will learn about aggregate transformation in ssis with an example aggregate transformation is used in data flow task to aggregate the data like sum max min avg etc example we have a table in sql server database which stores employees salary we will first create an ole db connection to fetch the data from the database and will perform aggregate transformation on the data to calculate sum max min salary for each department and aggregated data will be then exported to a flat file with pipe delimiter prerequisites sql server with ssis sql server data tools sql server management studio step 1 run sql server management studio connect to database and run below script to create employee salary table with some data create table empsalary empid char 6 deptid int salary numeric 18 2 insert into empsalary values emp001 1 50000 emp002 2 40000 emp003 2 25000 emp004 2 20000 emp005 3 30000 emp006 3 13000 emp007 4 23000 emp008 5 17000 step 2 run sql server data tools create a new project and add a shared data connection manager if already created in previous tutorial s open the existing project ssis tutorials step 3 add new package to the project name the package aggregate step 4 add data flow task to control flow tab double click data flow task to switch to data flow task tab step 5 add and configure ole db source add ole db source double click ole db source will open ole db source editor window select the shared data connection if not selected we created in step 2 select table empsalary step 6 add and configure aggregate transformation add aggregate to data flow task connect ole db source to aggregate double click aggregate to open aggregate transformation editor and configure the columns like below to find sum max min of salary department wise step 7 add and configure flat file destination add flat file destination connect aggregate to flat file destination double click flat file destination to open flat file destination editor click new to open a flat file format window click ok to open flat file connection manager editor click browse to configure the flat file path and name browse the path and name deptwisesalary in the file ...
Images from subpage: "www.itdeveloperzone.com/2016/07/" Verify
Images from subpage: "www.itdeveloperzone.com/2016/" Verify
Images from subpage: "www.itdeveloperzone.com/2017/10/" Verify
Images from subpage: "www.itdeveloperzone.com/2017/" Verify
Images from subpage: "www.itdeveloperzone.com/feeds/posts/default" Verify
Verified site has: 93 subpage(s). Do you want to verify them? Verify pages: