Link to home
Start Free TrialLog in
Avatar of Juan Velasquez
Juan VelasquezFlag for United States of America

asked on

Recommended SSIS

Hello,

I am working on a project to migrate several large access databases to a MSSQL 2016 database.  I've completed the migration and created all the stored procedures and necessary views as well as tables.  However, approximately 50 files will have to be imported into the database on a weekly basis. I don't know much about SSIS but have used the SQL Server Import and Export data tool to import the data.   I would like t use SSIS to import these files.   However, I don't know that much about SSIS.  What books would anyone recommend for learning SSIS. I've had quite a bit of database experience (MS Access and some MSSQL, including sql and T-Sql but minimal SSIS.  Thanks

Juan
ASKER CERTIFIED SOLUTION
Avatar of Jose Torres
Jose Torres
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Juan Velasquez

ASKER

Thanks Jose. I went ahead and did some additional research.  I found this series of tutorials at http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72492/

I am going to start with those, in order to get my feet wet.  

Thanks again Jose
Thanks for the advice