So 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.
In English it means, it is a platform which can be used to built applications which can transform the data from source to target in what is known as ETL framework. Extract, Transform, Load.
This is something I am learning as part of some project at my workplace in an attempt to migrate from Pervasive, which is use to do same thing (but is a tool from Actian). SSIS is from Microsoft so is more user friendly and can be easily integrated with existing Microsoft technologies.
I am trying to find out user guides over the Internet. My requirement is to find a guide which explains how to perform transformations from a Flat Text file and INTO a Flat Text file.
So far I have found many tutorials that transforms data from Flat file BUT to SQL Database (which as I am learning is a fairly common use).
MSDN: *msdn.microsoft.com/en-us/library/ms169917.aspx
Youtube: *www.youtube.com/watch?v=3cPq9FXk-RA&list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs
Anyone having any exposure or working experience in SSIS?
In English it means, it is a platform which can be used to built applications which can transform the data from source to target in what is known as ETL framework. Extract, Transform, Load.
This is something I am learning as part of some project at my workplace in an attempt to migrate from Pervasive, which is use to do same thing (but is a tool from Actian). SSIS is from Microsoft so is more user friendly and can be easily integrated with existing Microsoft technologies.
I am trying to find out user guides over the Internet. My requirement is to find a guide which explains how to perform transformations from a Flat Text file and INTO a Flat Text file.
So far I have found many tutorials that transforms data from Flat file BUT to SQL Database (which as I am learning is a fairly common use).
MSDN: *msdn.microsoft.com/en-us/library/ms169917.aspx
Youtube: *www.youtube.com/watch?v=3cPq9FXk-RA&list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs
Anyone having any exposure or working experience in SSIS?