• Skip to primary navigation
  • Skip to main content

ROB SYMONDS

  • Home
  • About

SSIS Foreach Loop Container and Access Databases

2008-08-22 By Rob Symonds

I was struggling today to get a Foreach Loop Container to trawl a directory full of Access databases. The problem was that I had not correctly built the ConnectionString for my source connection using the Expression Editor. I found my answer at http://www.mssqltips.com/tip.asp?tip=1437. I’ll give you a preview: “Data Source=” + @[User::mAccessLocation] + “;Provider=Microsoft.Jet.OLEDB.4.0;User ID=;Password=;”

Copyright © 2023 ยท Log in

  • RSS
  • Twitter
  • LinkedIn