dynamic destination table creation in ssis

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

dynamic destination table creation in ssis

Author

Topic

AnuVijay
Starting Member

32 Posts

Posted - 2011-11-16 : 10:11:52

Hi

How to create the sql server destination table based on the column list of the dbf file using ssis 2008?

Could any one help me to resolve this?

Thanks
Anu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-16 : 11:42:27

use dataflow task with OLEDB source using JET OLEDB provider for connecting to dbf file and OLEDB destination using sql server native provider for connecting to destination table.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

AnuVijay
Starting Member

32 Posts

Posted - 2011-11-17 : 04:53:40

I want to create the sql table (destination) dynamically based on the column list of the dbf files.

Can you tell me, how to do that in ssis?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources