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?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply