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.

learn more… | top users | synonyms

65
votes
13answers
7k views

My boss has a bad case of “Not Invented Here” [on hold]

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 ...
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 ...
3
votes
1answer
419 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?
1
vote
0answers
85 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: ...
0
votes
1answer
45 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
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.