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
SSIS

Avatar of undefined
Last Comment
Juan Velasquez

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jose Torres

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Juan Velasquez

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
ASKER
Juan Velasquez

Thanks for the advice
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck