Thanks, but both can be blank.  I can have a record with a blank name and email address, any unique names and an email address, but not both a...

Is this Oracle? If so I believe to_date casts a column to a date. The format code is to help with the conversion, not to add time, which might explain...

I think it's based on the default language for the login which can differ from the instance default language.

If the default is us_english then datefirst = 7 but most European...

I don't understand what you need to do. I presume that you don't want to union all query 1 with query 2. Do you need to left outer join parts...

Simple recovery mode...

thx jeffrey.  i'd like to restate the problem so that i can follow what you are saying.   and distinguish his code base changes from other changes.

server1 , db1 has...

Can you export it as .txt not .csv? This might encourage them to use a more appropriate tool. You have no control over their ability to use Excel.

If they insist...

If the Azure VM is a potential replacement I would change the connection to MSOLEDBSQL rather than install a deprecated connection on the SQL 2022 box.

I think you need to...

Have you tried to install the SQL Server Native Client on your dev machine? It doesn't ship with SQL 2022 so the connection is failing to acquire.

I would suggest changing...

I tried to create the tables, but the script didn't work. The table I tried was missing the first column and the nvarchar columns had no length so they were...

Right click the dataflow task itself and view properties. Have you tried using table or view -fast load? If you can achieve minimally logged inserts they are typically much faster.

If the spreadsheet is representative of your calendar table you appear to have inconsistent data. Most of the time the FY column has values like FY2021, FY2022, FY2023, FY2024, but...

page 2?

Due to security i could not export data from the particular DB. I imported the very same flat files into my personal DB , with no issue. YOU could...

Assuming you delete/append once per day, can you truncate the table if today is the 1st of August? This is set to truncate on the 2nd of July for testing....