Import from multiple Flat and excel files in the same folder

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Import from multiple Flat and excel files in...

Import from multiple Flat and excel files in the same folder

Rate Topic

Display Mode

Topic Options

Author

Message

engg.pankaj

Posted Tuesday, November 27, 2012 3:08 PM

Forum 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

Kumara1011

Posted Tuesday, November 27, 2012 10:46 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:53 AM
Points: 46, Visits: 108

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

Kumara1011

Posted Wednesday, November 28, 2012 12:42 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:53 AM
Points: 46, Visits: 108

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 »

Permissions