DataTool | 数据工作者必备工具箱

I am trying to deploy the SSIS developer toolkit to my Visual Studio 2019 instance. I tried yesterday's download as well as a new download today with the same result. Details are below. I will also look at another Stack post here and see if this helps in the meantime.

I don't have the experience to interpret the log file. Can someone assist?

MainViewModel.OnBundleAction: Bundle action failed: Unknown error (0x80131500) (0x80131500)

Error message result from Microsoft.DataTools.IntegrationServices.exe

Visual Studio 2019 version information - Updated to latest version

LOG File - See subsequent posts for full log file. Please note log file order. Stack posts it out of order.

I am quite new to python (and mainly want to use this for academic reasons), so please bare with my question!

I have collected twitter data through their dev academic account - however the amount is quite big, so I want to create a randomized sample. I already have the data as json as well as csv format.

I now want to get a randomized sample of x rows (let's say 1000 rows) (preferably for a specific column (column "CG" (header=text)) - if that's difficult values for the whole row should be regardded)

What I found is this code, that gives out randomized values.

1. How can I amend it in a way it will give out randomized rows, but not random values - so they will always contain the content from the same column?
2. How can I have this create a new csv with the randomized row data as sample?

P.s.: I also tried to get datatools running and make use of their csvrows tool, however although following the instructions I couldn't get the csvrow tool to run. datatools

MWE:

I am trying to get the second last value in each row of a data frame, meaning the first job a person has had. (Job1_latest is the most recent job and people had a different number of jobs in the past and I want to get the first one). I managed to get the last value per row with the code below:

first_job <- function(x) tail(x[!is.na(x)], 1)

first_job <- apply(data, 1, first_job)

I am a new python user here and am trying to append data together that I have pulled from a pdf using Camelot but am having trouble getting them to join together.

Here is my code:

I have built software that is capable of exporting DTSX package automatically. This package among other objects has also a ScriptTask (C#). All are compiled and run just fine.

Now the new requirement is to call a class in that ScriptTask, which exists inside an external DLL we have built, so other applications can consume the same code. We did our homework, and we included this DLL into the GAC successfully during the installation of the software.

The problem is that "using our library" is still not recognized in the script.

While searching a little bit, we figured out, that we need to reference this DLL also inside the References folder. This we can do it of course via DataTools / VisualStudio UI.

The issue is that we need to do that programmatically:

We have this piece of code that generates the Project

I'm trying to automate the task of querying for data on this site using Puppeteer. So I need to select the dataset (Daily Summaries, 1st option), then select location type (State, 3rd option), then select state (Alaska, 2nd option). The problem is my code does not change to the next table. So instead of selecting the 3rd option (State) after selecting the 1st option in dataset (Daily Summaries), it just selects the 3rd option but in dataset table again! I am new to Puppeteer so I don't really know what to do with this. Any help is appreciated.

Below is my code: