Viewing 15 posts - 1 through 15 (of 260 total)
Update: Steve's suggestion worked. 🙂 Thanks again.
October 14, 2020 at 5:21 pm
Thanks Steve. Fingers crossed. 🙂
September 30, 2020 at 9:06 pm
I'm not sure I fully understand what you're asking. But maybe you need to read up a bit more on database collation?
March 13, 2020 at 5:55 pm
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...
March 6, 2020 at 1:54 am
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...
March 5, 2020 at 5:58 pm
December 21, 2019 at 1:21 am
How about some nice triangular joins done inside a cursor? Jeff Moden: Look Away.
December 20, 2019 at 9:10 pm
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...
September 14, 2019 at 12:35 am
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...
September 13, 2019 at 11:34 pm
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...
September 13, 2019 at 6:25 pm
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?
September 13, 2019 at 3:02 pm
June 21, 2019 at 11:46 pm
You can specify the package's Target Server Version. Check out this link:
Please let me know if that helps.
June 19, 2019 at 11:45 pm
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...
June 4, 2019 at 10:02 pm
BEGIN TRANSACTION SELECT PrimaryKey INTO #MyTempTableFROM Table1WHERE Submitted_date < DATEADD(YEAR, -3, GETDATE());DELETE Table1WHERE EXISTS( SELECT NULL FROM #MyTempTable ...
May 30, 2019 at 10:47 pm