<div>
You can try store the tablenames you want to create in a table and use a stored procedure to create the tables... try it!<br />
Pedro<br />
<a href="http://www.pedrocgd.blogspot.com" rel="ugc">www.pedrocgd.blogspot.com</a>
</div>


You can try store the tablenames you want to create in a table and use a stored procedure to create the tables... try it!
Pedro
www.pedrocgd.blogspot.com [http://www.pedrocgd.blogspot.com]

<div>
thanks pedro, can u please give me that dynamic stored procedure<br />
for just 2 tables say file1 and file2..and if possible can u also<br />
let me know if can add that SP in the SSIS package ?<br />
many thanks..
</div>


thanks pedro, can u please give me that dynamic stored procedure
for just 2 tables say file1 and file2..and if possible can u also
let me know if can add that SP in the SSIS package ?
many thanks..

<div>
<div class="content wysiwyg-content">
i have to import multiple text files with same schemea format<br />
into different destination tables..<br />
bUT I think SSIS Cannot create destination tables on the fly..if this is the case, <br />
&nbsp;can we not load the data into a single<br />
table intially and then split them into different tables based on the filenames<br />
with the help of some stored procudure or .net code ?<br />
can anybody please help me.. Many Thanks
</div>
</div>


i have to import multiple text files with same schemea format
into different destination tables..
bUT I think SSIS Cannot create destination tables on the fly..if this is the case, 
 can we not load the data into a single
table intially and then split them into different tables based on the filenames
with the help of some stored procudure or .net code ?
can anybody please help me.. Many Thanks

SSIS multiple Destination tables

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.