Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [ssis]

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications.

12 questions
65
votes
13 answers

My boss has a bad case of "Not Invented Here"

My department specializes in converting customer data into our database schema so that they can use our software. Right now, we have C# applications that take an IDataReader (99% of the time it is a SqlDataReader), perform some cleaning and mapping,…
Scott Chamberlain
  • 877
  • 7
  • 19
6
votes
6 answers

What are the disadvantages of using stored procedures, SSIS, and SSRS to implement business applications?

Recently, it was suggested that many projects (where I work) should be implemented using some combination of stored procedures (on SQL Sever / T-SQL), SSIS, and SSRS. In one specific project, SSIS would get a file from a SFTP server. The file…
James
  • 285
  • 1
  • 5
  • 13
3
votes
1 answer

Using SSIS, any good tutorials

I was look for a good resource to learning SQL Server business Studio and in particular SSIS packages, any sugguestions?
Nickz
  • 1,430
  • 1
  • 13
  • 18
2
votes
1 answer

SSIS Survivorship Nodes

Are there any matching and survivorship nodes in SSIS besides the one offered by Melissa Data? Any implementations in SQL on survivorship would be great as well. An example on my use case is that given that I have some 2 records of referring to the…
mtryingtocode
  • 121
  • 2
1
vote
1 answer

MS SSIS as good approach for two-way data synchronization

We have SQL Server databases in every retail store, and one database in main office. We want to collect data from all stores and load the main DB (for BI), but we also want to sync data from main DB to retail DBs, when new product is awailable for…
vpetrovic
  • 121
  • 4
1
vote
2 answers

Using Entity Framework as substitute for SSIS, SSAS and SSRS

At the moment I have three different sources where my data are. 1. A Dataprovider, 2. inhouse access DB and 3. Salesforce. Now I want to build a datawarehouse (using ms software) where I want to store the data and create reportings via e.g asp.net…
ruedi
  • 133
  • 10
0
votes
2 answers

Is there a better way to trigger API calls from an on Prem SQL Server without using a job scheduler?

I'm not sure if this is the correct area to ask this question, quite honestly, I'm not sure how to phrase the question because I don't know if what I'm thinking is possible. I'm trying to figure out a better way to trigger third party API calls from…
hnewbie
  • 1
  • 4
0
votes
0 answers

How best to design SSIS packages for multiple table loads

This is a question about SSIS package design. We have an SSIS package built in VS 2008 that loads ~ 22 tables from as many fixed width files into a data warehouse. Each file has its own data flow task. All of the data flow tasks are inside a single…
matt-in-the-hat
  • 11
0
votes
1 answer

Data Integration Design Using Microsoft SSIS

I am working on a data integration project, where I need to extract data from oracle source and load it to XML file. The requirement is to get the list of customers and foreach customer create an xml file with customer data and its associated…
sab
  • 109
  • 1
0
votes
1 answer

Optional text qualifier in CSV file as input to SSIS package

I receive several CSV files each quarter to process through an SSIS package, and the formatting is inconsistent. This quarter, I encountered what I term optional text qualifiers--text qualifer of double quote (") used at times, but not always. We…
Kennah
  • 268
  • 2
  • 6
0
votes
1 answer

Compare SSIS and MDS/DQS

How does Master Data Services and Data Quality Services fit into the existing BI stack? In SSIS there is a Fuzzy Lookup and Fuzzy Grouping component. Therefore I am tring to compare: SSIS v MDS/DQS. From what I understand MDS/DQS is the preferred…
w0051977
  • 7,031
  • 6
  • 59
  • 87
0
votes
2 answers

SQL Server: When to use SSIS vs T-SQL for ETL Tasks

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
Robert
  • 165
  • 7