I am pretty much a beginner on this area( development, more in the technical area), but I am really in need of some help. I have a client that is running a transportation program in a SQL 2005 server. Their software vendors recommended for them to use SSIS to create a Datawarehouse to run some reports from this db. I am pretty much lost and do not know where to start. I know that SQL has some wizards to create these packages, but I would like to know if someone like me could actually tackle this task or should I just try to hire a developer. I have used DTS in older versions of SQL. Could anyone guide me on where to start or maybe a tutorial. We just need to migrate the data from the production db to the report db.
Thanks in advance.