Juan Velasquez
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the advice
ASKER
I am going to start with those, in order to get my feet wet.
Thanks again Jose