Click here to Skip to main content
16,015,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I am new to SSIS packages. I am writing an SSIS package which copies all tables from an Access Database to SQL Server Database.
I am using an ADO.NET Source and OLEDB Destination in DataFlow which resides inside a ForEach Loop Container.
Everything is working fine, if the tables are already there in SQL Server Database.
What I want to do is, to create the non-existing tables in SQL Server. (This access db is subject to expand heavily later)

How can I do this in OLEDB Destination ?

Thanks
Posted

1 solution

 
Share this answer
 
Comments
Yesudass Moses 4-Dec-14 5:40am    
That's not I want.
I want to create a table dynamically in SQL Server if it finds a new table ins access DB. using the schema info from Access DB.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900