Update: Steve's suggestion worked. 🙂 Thanks again.

Thanks Steve. Fingers crossed. 🙂

I'm not sure I fully understand what you're asking. But maybe you need to read up a bit more on database collation?

https://www.red-gate.com/simple-talk/sql/sql-development/questions-sql-server-collations-shy-ask/

I wouldn't add this identifier column to your table at all. It can just be derived from existing data across multiple tables. What happens if they change the name of...

• This reply was modified 4 years, 8 months ago by  autoexcrement. Reason: no need for inner join anymore

I don't think you really want or need to add such a column to your table. But if you need to return such a value for some type of reporting...

https://www.sqlservercentral.com/articles/hidden-rbar-triangular-joins

How about some nice triangular joins done inside a cursor? Jeff Moden: Look Away.

Yeah no argument that that solves the problem. I'm just still kinda surprised by how this played out and that there's no setting on the SQL Server side. But good...

So the only way to do what I want is for SSIS to notify me right off the bat if the source file has data longer than I'm expecting? It...

Thanks, I tried that and saw that the data was NOT truncated on the SSIS side.

The source file is Excel so it's just a generic text field that SSIS considers...

Thanks so much for the reply, but I can't see that that's the problem. Maybe you can look at these screenshots and let me know what I may be missing?

Here's...

Terrific! 🙂

You can specify the package's Target Server Version. Check out this link:

https://zappysys.zendesk.com/hc/en-us/articles/115004811573-How-to-change-SSIS-Package-Version-in-Visual-Studio-2015-or-Higher

Please let me know if that helps.

It sounds like your SSIS package(s) is using Package Configurations. This is a way to set the values of variables and other elements inside the package during run time. It...

BEGIN TRANSACTION 

SELECT PrimaryKey 
INTO #MyTempTable
FROM Table1
WHERE Submitted_date < DATEADD(YEAR, -3, GETDATE());

DELETE Table1
WHERE EXISTS
(
     SELECT NULL
     FROM #MyTempTable
 ...