Viewing 15 posts - 586 through 600 (of 2,079 total)
At work we did it parameterising the Connection property of the package-level OLEDB connector (which allows parameterisation)
MyProcessingFile is set with the for-each iterator
Connectionstring
"Data Source=" + @[User::MyProcessingFile]...
April 6, 2018 at 8:09 am
in memoriam. Didn't know Robert but he wrote good blogs.
April 5, 2018 at 3:46 am
Looks like the data-driven subscription functionality
https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions
March 14, 2018 at 4:03 am
Testing spring cleanup subscriptions. We're getting 10+°C in wintertime
January 25, 2018 at 5:21 am
Trace command on the source why it takes so long? Play with decreasing/increasing buffer sizes
January 10, 2018 at 8:58 am
Have a look at the FileShareStorageLocation parameter
You can tell SSRS to store the temp/swapfiles somewhere else
January 5, 2018 at 6:22 am
Sorry polluting sql 2017 administration. Why can't migrating SSRS to 2017 be simple?
October 17, 2017 at 2:53 am
It didn't like the VirtualServiceAccount it was running under;
Changed to an active directory account and it connected
October 16, 2017 at 9:04 pm
October 5, 2017 at 8:19 am
From memory
1. Can you connect to the windows 2012 vm remotely? The vm might use an internal network.
2. SQL Configuration Manager: is TCP protocol enabled?
3. The SQL...
September 14, 2017 at 8:00 am
Source control is important so you can rollback to a previous version.
c# pro:
no license of SSIS needed
flexibility
c# contra:
requires c# skills
no visual flow control
September 14, 2017 at 4:40 am
Searched the web a little further. Refs not supported on san-storage?
Not yet recommeded for clustered volumes due "redirected mode" ( Redirected mode: can't bypass...
September 14, 2017 at 3:35 am
Refs is supported but I can't find more information. Have you tried it in a test-environment?
Refs seems to have a memory impact
September 13, 2017 at 8:59 am
Viewing 15 posts - 586 through 600 (of 2,079 total)