April 6, 2008 at 11:38 pm
Thanks in advance!
I am new to SQL Server Development. I will be working on a project which requires a good understanding of SSIS. What are the usual scenarios or tasks I will be given when working on SSIS? Please help!!
April 8, 2008 at 6:47 pm
Hi, that's like asking what will you be asked to build with C, the programming language, if you were being asked to learn it. I cant answer that but SSIS is used for the ETL dataflow paradigm. That basically means that in order to transfer data from one area of storage to another it has to go through a transformation. An example would be moving an Excel list into a SQL SERVER table. SSIS actually allows you to also email yourself if the process completed, FTP a copy to a remote server, check for data integrity using fuzzy lookups (to catch typos if you were just being asked to clean up data.) I hope I understood your question correct.
Of course the best way to learn is to play with it yourself.
----------------------------------------------------
April 8, 2008 at 8:43 pm
Thanks for your reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply