The tag has no usage guidance.

learn more… | top users | synonyms

3
votes
4answers
5k views

Not able to create SSISDB catalog

Getting the error below while trying to create a catalog in sql server 2014 integration services. Any idea what I missed in installation or anywhere else? The catalog backup file 'C:\Program ...
3
votes
2answers
249 views

Can PostgreSQL support integration test with some kind of throwaway overlay?

It's a common problem to write integration tests that include a database. If the test changes the database then it could effect other tests or the next run of itself. I know that I could wrap my test ...
1
vote
1answer
22 views

decrypt data in column before load into destination

I have a table named city which contains two columns city_id (int) city_name (varbinary) -- encrypted column I want to extract data from this table, transform (decrypt the city_name) and load ...
1
vote
1answer
163 views

SQL User Permissions for Continuous Integration via DbUp and Octopus

Currently, our deverloper group has started using DbUp and Octopus to do Continuous Integration on SQL Database Deployments. We have created a Domain user which will utilized to do the SQL Database ...
1
vote
2answers
4k views

Does MySQL have a version of Change Data Capture?

We're in the process of phasing out an old system and migrating onto a new one. The last time that we phased out an old system, we ran both systems in parallel and integrated data between both until ...
1
vote
0answers
48 views

Data Integration [closed]

This is not exactly a DBA question but definitely a DB question and I think StackExchange DBA is my best bet for this question. Here I go : are there any frameworks ( free / open source preferred ) ...
0
votes
0answers
113 views

Could not load file or Assembliy “SecureBlackBox.dll”

Task- To Send csv files to Secure FTP. Problem: Script Task using Third Party DLL for Secure FTP mainly "Eldos" is not able to load dll ,when deployed on integration server. Resolution Usually i ...
0
votes
0answers
507 views

Service Broker received an error message on this conversation

I will first have to say, I am still trying to wrap my brain around all the components of the Service Broker and how they work together, so it's very likely I'm missing something obvious... it's just ...
0
votes
0answers
108 views

Create replication sql server for DWH [closed]

I have a DWH and I need to make an update once a day from STG Database to DWH I need use replication in SQL SERVER, How I do this?
0
votes
0answers
48 views

Merge data using Integration Service

Please Consider this scenario: I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how ...
0
votes
0answers
111 views

How to/advice for hosting a multi-user database on the cloud with specific objectives

I have developed an application that users will be able to download and create an account with through our company. This application will always be connected to the internet. I have been testing the ...