Please make a video on how to distribute the total load among multiple server using WLM concept while uploading an excel or csv file to our control room database. Use both queue and device pool concept ideally. It would be more beneficial for people who wants to learn in details about the benefit of WLM using AA.
Delete action/query will not work when we use Excel as a database. You can use the delete cells option after reading data using get cells action under excel advance package and looping through the data which is being stored in a table variable.
To check if everything has been inserted successfully you can cross verify each and every row of data from excel and use select query in SQL server mgmt studio and check if each and every row of data is matching or not from excel
Please make a video on how to distribute the total load among multiple server using WLM concept while uploading an excel or csv file to our control room database. Use both queue and device pool concept ideally. It would be more beneficial for people who wants to learn in details about the benefit of WLM using AA.
Thanks for making videos on this IMP Topic.
Please make a video on how to perform delete action when excel is being used as database
Delete action/query will not work when we use Excel as a database.
You can use the delete cells option after reading data using get cells action under excel advance package and looping through the data which is being stored in a table variable.
When I used conditional and Loop statements,got exception? Aw snap!.? could you please help me
Yes we can connect tomorrow afternoon at 3 PM
How to cross check after we insert data from an excel to to a database , that the data from the dataset has correctly populated in the database?
To check if everything has been inserted successfully you can cross verify each and every row of data from excel and use select query in SQL server mgmt studio and check if each and every row of data is matching or not from excel
Is it enterprise edition?
Yes it is enterprise edition