Dynamically build connection objects for Microsoft Access databases in SQL Server Integration Services

(Hal Hayes) As a portion of our daily data upload process, we receive data in the form of Microsoft Access files (*.mdb) which needs to get uploaded to a SQL Server 2005 database. We want to build a SQL Server 2005 Integration Services package that loads all our Microsoft Access files and uploads d

Read More - Register for Free Membership