Viewing 15 posts - 1 through 15 (of 57 total)
Hey MVDBA
Thanks for getting back. The scenario i'm looking at here is the report (rdl) getting deployed to the right folder for Vendors but accidentally using a shared datasource consequentially...
October 28, 2019 at 2:20 pm
Wasn't sure if I saw where TLS1.2 was enabled in registry on the server. Additional I think this has been mentioned, we also had to upgrade to SQL Server 2012...
October 28, 2019 at 10:52 am
I second with Eirikur Eiriksson. I have also run into...
May 30, 2018 at 1:06 pm
I just posted here.
Im having the exact same problem in SSDT
https://www.sqlservercentral.com/Forums/1872860/AGGREGATE-FUNCTION-hanging-against-SSAS
May 9, 2017 at 2:08 pm
After almost 2 weeks of research i have been able to locate my problem. Someone posted on this forum 5 years again with the EXACT same problem
https://www.sqlservercentral.com/Forums/Topic1246499-17-1.aspx
May 9, 2017 at 1:55 pm
Good to know article - i still need a way to build the expression to always use the current password. it doesn't...
December 6, 2016 at 1:51 pm
Thanks so much for getting back guys. So we have a number of shared data sources in the system connecting to SQL boxes and yes to all your points, those...
December 6, 2016 at 1:46 pm
Been a while I know but I just wanted to give feedback. I essentially created a table (SSIS_Mapping) with various columns one being the infamous auto_flag INT column.
All the...
August 1, 2016 at 2:16 pm
Awesome!! MY team and I will review this concept. We are planning something similar and I like how you have this done. Ill reach out if I have any other...
June 22, 2016 at 4:25 pm
One parameter to imply default or override behavior, and two date parameters where you can manually edit your date range. Since you are using package parameters,
I like the idea...
June 14, 2016 at 12:41 pm
Thanks JustMarie
So this is sounding like a two step process. Have a sproc update the start and end dates then call the SSIS package to run with the updated dates....
June 14, 2016 at 12:39 pm
If one data source for 2 files then you need to look at Multicasting which allows you to feed multiple destinations with the same source subject to structures being identical...
June 14, 2016 at 9:00 am
As in the words of Frank Caliendo doing a George Bush impersonation, "Gial - it does make sense. ":-D
I do concede and will be going with what the powers that...
April 12, 2016 at 8:15 am
No, it's not. Neither is the DB diagram being restricted to a DB showing a lack of forethought
The database is the the unit for enforced integrity, backups, restores, etc. It's...
April 12, 2016 at 7:26 am
Hey Jeff
Thanks for this suggestion. I did consider using triggers across our databases but one reason has me worried about this.
Performance. Our design essentially will be querying millions...
April 11, 2016 at 7:25 am
Viewing 15 posts - 1 through 15 (of 57 total)