Access Schemas

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Access Schemas

Access Schemas

Rate Topic

Display Mode

Topic Options

Author

Message

sandyinfowave

Posted Monday, March 18, 2013 12:10 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 21, 2013 11:21 AM
Points: 53, Visits: 1,031

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

Post #1432298

Phil Parkin

Posted Monday, March 18, 2013 12:17 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 4,323, Visits: 9,662

Can you provide a bit more background?

What do you want to do with the schema once it has been extracted?

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1432303

sandyinfowave

Posted Wednesday, March 20, 2013 10:51 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, March 21, 2013 11:21 AM
Points: 53, Visits: 1,031

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

Post #1433346

Phil Parkin

Posted Wednesday, March 20, 2013 10:57 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 4,323, Visits: 9,662

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.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1433348

« Prev Topic | Next Topic »

Permissions