moving data into praraw table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » moving data into praraw table

moving data into praraw table

Rate Topic

Display Mode

Topic Options

Author

Message

narendra.kongara

Posted Tuesday, November 27, 2012 10:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 2:20 AM
Points: 2, Visits: 14

i have 10 text files in a folder and also have three tables in sql server data base.depending on the file name i need to move the data into pre_raw table's by using ssis package.
Any one have done this before give me some clarification.

Post #1389506

Kumara1011

Posted Tuesday, November 27, 2012 10:23 PM

SSC Rookie

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

If u r considering the name, then there should be 10 tables for those 10 files.
Or else u need something other than this then mention clearly what exactly u r excepting.

Post #1389507

Kumara1011

Posted Tuesday, November 27, 2012 10:31 PM

SSC Rookie

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

on way using Precedence constraints we can do that.

Post #1389508

« Prev Topic | Next Topic »

Permissions