Viewing 15 posts - 1 through 15 (of 262 total)
We really just need a way to view/export the results of the reconstituted queries. Thanks for your thoughts on this project though, I think I will pursue a non-SQL approach...
May 5, 2022 at 4:22 pm
Thanks for the reply, Phil! I think I could handle a simple query like that as well. Where it starts getting rough for me is when there are [x] number...
May 5, 2022 at 3:20 pm
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?
https://www.red-gate.com/simple-talk/sql/sql-development/questions-sql-server-collations-shy-ask/
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
https://qa.sqlservercentral.com/articles/hidden-rbar-triangular-joins
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?
Here's...
September 13, 2019 at 3:02 pm
Terrific! 🙂
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
Viewing 15 posts - 1 through 15 (of 262 total)