David McAfee
davidmcafee at gmail.com
Thu May 8 11:10:32 CDT 2014
Hi all, I've been busy working at my new job with SQL related tasks. My current project is to import a huge (120 column) table from 710 access databases spread around 14 network locations into SQL server. I've created an SSIS package that loops through a recordset of connection strings and database paths, importing new and changed records into a master load table. The SSIS package normalizes the data a bit into and places the data in their respective locations, then truncates the load table and continues the loop. I've altered my Database and set the Recovery to Simple. I run the package in batches of 10-20 mdb imports just to check things out. I shrink the log file after every batch (which grows pretty big). Is there any tips that can save me some time and possibly space? Thanks in advance, David