Viewing 15 posts - 481 through 495 (of 2,044 total)
We use SSIS a lot for our ETL. Recommended is VS2017 + data tools , VS 2019 is extremely buggy at the moment.
Pro's:
Flowchart, logging, catalog, almost no code required but...
October 31, 2019 at 4:48 pm
Provider cannot be found. It may not be properly installed-> Is the oracle driver installed on the sql server and/or the client?
October 31, 2019 at 4:38 pm
Knocking on wood, just updated to vs 2019 16.3.6 and got the "variables" showing again
October 29, 2019 at 4:04 pm
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
October 29, 2019 at 3:54 pm
Not really TFS, but about automating: DBAtools has a wonderful library of powershell-scripts regarding sql server
October 29, 2019 at 3:45 pm
I'm also curious. I would expect a slight increase of load. More frequent logshipping = smaller logs, more frequent copying and apply(?). Same bandwidth use overall. Impact for the provider...
October 25, 2019 at 2:14 pm
We have a report on failed subscriptions that is mailed mid-day. If we don't get the mail something is also wrong. In addition a report with commands to retry subscriptions...
October 17, 2019 at 3:35 pm
Why I worry less about fragmentation: there are so many different layers between sql server and the hardware storage if you are running virtualized or with SAN-storage.
Statistics are more important...
October 17, 2019 at 3:28 pm
Is on-premise. Tried the Attunity Connectors but can't find how to use expressions (SQL command from variable) for incremental updates.
October 17, 2019 at 3:21 pm
Have a look at the ExtendedEventsWorkloadListener of WorkloadTools
The tool is designed to replay or analyse a workload from system A to system B using Extended Events.
It has a...
October 17, 2019 at 1:41 pm
Doesn't seem to make a difference. I'll have to try it in a proper testing environment
October 17, 2019 at 8:37 am
Oracle driver oddities: create table as select * @from_dblink 1 minute. SSIS select * + rowcount: 80 minutes with Oracle Oledb 🙁
October 16, 2019 at 12:22 pm
A couple of years ago you needed to install VMWare guest tools to install better drivers for virtualization. Otherwise it would fall back to the much slower cpu-virtualization
Don't know if...
October 15, 2019 at 2:39 pm
I don't have experience with it, but it seems you can move resources between subscriptions.
https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-move-resources
October 2, 2019 at 3:07 pm
Service account of instance has access to the share?
May 28, 2019 at 2:20 pm
Viewing 15 posts - 481 through 495 (of 2,044 total)