Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import from multiple Flat and excel files in the same folder Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 3:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 1:42 PM
Points: 8, Visits: 20
Hi there,

Need help with importing from multiple Flat and excel files in the same folder (or its sub-folders) into a SQL table. The flat file and the excel sheets have the same structure.

I know how to import from Multiple text files (Or excel files) by the use of For Each Container, however I do not know what to do when to import both type of files i.e. Excel as well as flat files in the same task.

Can someone please help?

Thanks
Post #1389433
Posted Tuesday, November 27, 2012 10:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 4:10 AM
Points: 46, Visits: 115
we can write a condition in precedence constraints like which type of file need to send.
we can send that to same destination taking 2 OLE DB destination with same table.
Post #1389509
Posted Wednesday, November 28, 2012 12:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 4:10 AM
Points: 46, Visits: 115
small example :

right("D:\\filesource\\emp1.xls",3)=="xls"
right("D:\\filesource\\emp1.txt",3)=="txt"

mention this condition in precedence constraint to send text files to one destination and excel to other destination using same table in OLE DB.
Post #1389546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse