The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
19 views

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. ...
1
vote
0answers
38 views

SSIS developer using local data needs to call web services efficiently and interested in patterns [closed]

I have some experience writing ETL programs using Microsoft SQL Services Integration Services (SSIS) Packages and SQL Server Stored Procedures. Once, I needed to call a web service as part of the ...
1
vote
0answers
67 views

UML diagram for SSIS process

I'm trying to do some technical documentation and would like to include some diagrams to better explain the processes in the system. The process I'm currently trying to describe is the following: ...
-1
votes
2answers
1k views

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

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.
4
votes
6answers
7k views

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

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 ...
65
votes
13answers
6k views

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 ...
4
votes
5answers
3k views

SSIS: How long does it usually take to bring a new hire up to speed? [closed]

I’m a self-taught SQL developer that has worked for small to mid-sized companies. Most of my experience has been writing SQL statements for reporting, data scrubs, and never in a formalized IT ...
3
votes
1answer
410 views

Using SSIS, any good tutorials [closed]

I was look for a good resource to learning SQL Server business Studio and in particular SSIS packages, any sugguestions?