DBA | DBA : Averaging for Dynamic Time Warping | Time Series Database library

I have a requirement to build a SSIS package that sends HTML formatted emails and then saves the emails as tiff files. I have created a script task that processes the necessary records and then coverts the HTML code to the tiff. I have split the process into separate packages, the email send works fine the converting HTML to tiff is causing the issue.

When running the package manually it will process all files without any issues. my test currently is about 315 files this needs to be able to process at least 1,000 when finished with the ability to send up to 10,000 at one time. The problem is when I set the package to execute using SQL Server Agent it stops at 207 files. The package is deployed to SQL Server 2019 in the SSIS Catalog

What I have tried so far

I started with the script being placed in a SSIS package and deployed to the server and calling the package from a step (works 99.999999% of the time with all packages) tried both 32 and 64 bit runtime. Never any error messages just Unexpected Termination when looking at the execution reports. When clicking in the catalog and executing package it will process all the files. The SQL Server Agent is using a proxy and I also created another proxy account with my admin credentials to test for any issues with the account.

Created another package to call the package and used the Execute Package Task to call the first package, same result 207 files. Changed the execute Process task to an Execute SQL Task and tried the script that is created to manually start a package in the catalog 207 files. Tried executing the script from the command line both through the other SSIS package and the SQL Server Agent directly same results 207 files. If I try any of those methods directly outside SQL Server Agent the process runs no issues.

I converted the script task to a console application and it works processing all the files. When calling the executable file from any method from the SQL Server Agent it once again stops at the 207 files.

I have consulted with the companies DBA and Systems teams and they have not found anything that could be causing this error. There seems to be some type of limit that no matter the method of execution SQL Server Agent will not allow. I have mentioned looking at third-party applications but have been told no.

I have included the code below that I have been able to piece together. I am a SQL developer so C# is outside my knowledge base. Is there a way to optimize the code so it only uses one thread or does a cleanup between each letter. There may be a need for this to create over ten thousand letters at certain times.

Update

I have replaced the code with the new updated code. The email and image creation are all included as this is what the final product must do. When sending the emails there is a primary and secondary email address and depending on what email address is used it will change what the body of the email contains. When looking at the code there is a section of try catch that sends to primary when indicated to and if that fails it send to secondary instead. I am guessing there is a much cleaner way of doing that section but this is my first program as I work in SQL for everything else.

Thank You for all the suggestions and help.

Updated Code

Scenario

I wish to SELECT from a table with simple varchar and integer columns and return a JSON representation of the whole table. This is so that later I can use PhP's curl() to send the 'table' to another server and reconstruct it. I'm using MySQL ver 8.0.28-cll-lve on a remote, shared, server hosted at my ISP. I do not have admin access to the server itself, just all access rights to use and maintain the database.

What I have tried

The code below and in this SQLfiddle in response to this post on Stack Exchange's 'Database Administrators' plus several other posts on SO on the exactly the same topic (I won't list them all as I expect the first reply will tell me this question duplicates them)

Sample code that should work

i am in a bit tricky situation. I fetch some price values from a sqlite db and store it in a react state.

the response looks like: [{"price":50},{"price":"49,95"}]

i need to store these values as TEXT insted of INTEGER, because i have a lot of differrent decimal places. also using float in sqlite will not give me exact values, see the problem in this example: https://dba.stackexchange.com/questions/15729/storing-prices-in-sqlite-what-data-type-to-use

So to my main problem: how can i extract and convert the values from the json array to numbers, and sum it up?

I am trying to execute an SSIS package using a Credential and Proxy - it works fine with a user with a SysAdmin role and we want to avoid using SysAdmin.

I have followed all the steps to create a Credential and Proxy and set up the permissions for the user in msdb and SSISDb tables and in the Security -> logins

I have followed the steps in the below links as a guide:-

• Run an SSIS Package Under a Different Account
• Running a SSIS Package from SQL Server Agent Using a Proxy Account
• SQL Server Agent - Running SSIS Package with Proxy

Proxy -> properties -> Principals

When I run the job I get the below error - looks like a permission issue

Unable to start execution of step 1 (Reason: Could not get proxy data for proxy_id = 198_. The step failed.

What am I missing?

I am using mongo@4.2.1. In this package the openUploadStreamWithId in the GridFSBucket is defined as ObjectId.

mongodb.d.ts

I've gotten locked out of my Oracle APEX workspace. It is hosted locally, not in the Cloud.

The reset password won't help, as the account is tied to an email address of an employee who left.

The DBA has the credentials of an account of a different workspace.

Is there any procedure to reset this account's password?

I am working on a project that takes students attendance in class and I want to update the database data through PHP whilst running a SQL function of UPDATE, but I want to be able to update it base on the id of the data.

This is the code that I am working with at the moment.

I'm working on a Java client based code that is tryint to connect to snowflake JDBC with a private key I have searched online and found this links:

https://domohelp.domo.com/hc/en-us/articles/360042931854-Snowflake-Using-Key-Pair-Authentication-Connector

https://docs.snowflake.com/en/user-guide/jdbc-configure.html and other links, all required to use passphrase

and my code

I am trying to build a simple example using the Graph capabilities in Oracle DB, and hitting a problem running a SPARQL query. I added some data as shown in the guide, and that seemed to work properly. Next I tried running a simple SPARQL query using the SEM_MATCH function: