Viewing 15 posts - 1 through 15 (of 57 total)
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
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
May 9, 2017 at 1:55 pm
Could you look at this article about SSRS credentials[/url]
Could you look at this article about SSRS credentials
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.
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
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
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