SSIS multiple Destination tables

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
Who is Participating?
PedroCGDConnect With a Mentor Commented:
CREATE PROCEDURE usp_createtable_dinamic
      @myTable as varchar(30)
DECLARE @SQL nvarchar(max)
    SET @SQL='CREATE TABLE ' + @myTable + '       
      (ID int NULL,
      [Volume] [int] NULL,
      [AdditionalData] [varchar](50) NULL
You can try store the tablenames you want to create in a table and use a stored procedure to create the tables... try it!
gvamsimbaAuthor Commented:
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..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.