May 26, 2012 at 6:51 am
Hi, friends..i am new to this forum as well as msbi also, i have been learning msbi one of my friend he also know only basics...i am looking for some real time scenarios on ssis or etl flow of any ssis project to understand. so kindly pls send.
May 26, 2012 at 8:33 pm
Still looking..no one respomding?
May 28, 2012 at 12:15 am
Any project even a package to load text data to SQL Server tables can be very resourceful to explore the insights.
Check this link:
http://www.mssqltips.com/sqlservertutorial/207/creating-a-simple-ssis-package/
Raunak J
May 28, 2012 at 7:46 am
Thnaks Raunak Jhawar , it will really helps to me
May 29, 2012 at 4:14 am
Hi,
When I started playing with SSIS I used the UK postcode CSV file from the wikileaks website. It has over 1.8 million rows.
They say you need bzip2 to uncompress, You dont just use 7zip or winrar.
The data is not the cleanest and does have aquite a few errors but this will allow you to use DataConversions and Derived Columns etc to sort it out.
About 10% of the Co ordinates are missing but I have a script that will go off and find these for you. I can send you the details at a later date.
Hope this gives you something to work with. It definatly helped me.
Colin
Here is the link the script i used to get the GIS location
May 30, 2012 at 5:32 am
You can also download the Adventure Works sample databases of Codeplex and start playing with those. There are a lot of SSIS tutorials out there, even on the MSDN website.
Try to upload a simple Excel sheet to SQL Server, it will be challenging enough 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply