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

moving data into praraw table Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 10:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 12:50 AM
Points: 2, Visits: 27
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
Posted Tuesday, November 27, 2012 10:23 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:18 AM
Points: 46, Visits: 114
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
Posted Tuesday, November 27, 2012 10:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 14, 2014 1:18 AM
Points: 46, Visits: 114
on way using Precedence constraints we can do that.
Post #1389508
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse