March 18, 2013 at 12:10 pm
I was recently assigned a task of dynamically extracting Access schemas...How do i approach using SSIS..Any thoughts or suggestions would be highly appreciated
March 18, 2013 at 12:17 pm
Can you provide a bit more background?
What do you want to do with the schema once it has been extracted?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
March 20, 2013 at 10:51 am
Phil, thanks for your reply....all i wanted to do i dynamically extract Access schema and create views to insert data into database....In other words all i wanted to do is process any Access file(irrespective of schema type) and insert data into database
March 20, 2013 at 10:57 am
From Access to SQL Server, presumably?
So you want to create a loop which iterates around all tables in a selected Access database, and for each table it should create the table in SQL Server and then populate it?
Not easy at all. I'd just stick to the upsizing wizard.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply