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 12»»

ssis flatfile data to database table prob Expand / Collapse
Author
Message
Posted Monday, August 27, 2012 7:30 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 206, Visits: 4,489
hi friend i have a small doubt in ssis plz tell me how to solve this prob

all columns are separete with $ symbole
flat file soure data like columns are 1000 no of columns i given some sample columns like this
ab $ 1234 $ xyz $678
1 $ 100 $5000$258
2 $ 2500 $3600$356
3 $36500 $ 35200$147
so this data load into database tables.
here first load ab columns data once load ab data then it will be truncate before load 1234 columns data once load 1234 columns data it will be truncate before load xyz columns data like this way we do what ever columns in flat filses we do same way.
plz tell me what logic we apply here


i do like this way i taken sequencce container in controlflow lever and taken 4 dataflow tasks in 4 dft bottom i taken 4 execute sql tasks
dft1 i cofigrure flat file sourece and i select requerd column in 1st table that is ab columns and configure to destingation table .and dft1 bottome i taken execute sql task that time i write query truncate table tablename.
like this way i do remain three columns.
but here flat file source contains so many columns .
how we do dynamicaly load and truncate .plz tell me
Post #1350378
Posted Monday, August 27, 2012 1:50 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:30 AM
Points: 31, Visits: 105
do you want to load all data into the same table? I am asking this because probably i do not understand your question very well. I am a bit confused because you said you have 4 different DFTs in your ssis package.
Post #1350561
Posted Monday, August 27, 2012 9:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 206, Visits: 4,489
its load data different table
Post #1350673
Posted Monday, August 27, 2012 9:27 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:52 AM
Points: 716, Visits: 350
asranantha (8/27/2012)
hi friend i have a small doubt in ssis plz tell me how to solve this prob

all columns are separete with $ symbole
flat file soure data like columns are 1000 no of columns i given some sample columns like this
ab $ 1234 $ xyz $678
1 $ 100 $5000$258
2 $ 2500 $3600$356
3 $36500 $ 35200$147
[highlight=#ffff11]so this data load into database tables.
here first load ab columns data once load ab data then it will be truncate before load 1234 columns data once load 1234 columns data it will be truncate before load xyz columns data like this way we do what ever columns in flat filses we do same way.[/highlight]
plz tell me what logic we apply here


i do like this way i taken sequencce container in controlflow lever and taken 4 dataflow tasks in 4 dft bottom i taken 4 execute sql tasks
dft1 i cofigrure flat file sourece and i select requerd column in 1st table that is ab columns and configure to destingation table .and dft1 bottome i taken execute sql task that time i write query truncate table tablename.
like this way i do remain three columns.
but here flat file source contains so many columns .
how we do dynamicaly load and truncate .plz tell me



Can u please elaborate marked ...
Post #1350676
Posted Monday, August 27, 2012 10:13 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 2, 2014 7:24 PM
Points: 286, Visits: 572
Just a thought. Wouldn't it be easier to simply pull the entire file into a single staging table, and then manipulate it out of that table into whichever destination tables you require. Presumably this would be easier than going back and forward to the flat file for every single column?

Clare
_________________________________________________________________________________________________________________
Measure twice; cut once (and have a good saw)

Hey, just a thought.....did you check Books Online yet?
Post #1350682
Posted Tuesday, August 28, 2012 3:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 1:33 AM
Points: 4, Visits: 2
Hi,
Search "schema.ini" file in relation with "Microsoft OLEDB Text driver". U'll definately get answer to your Problem. If not i'll tell you tomarrow!!
Post #1350756
Posted Tuesday, August 28, 2012 9:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 206, Visits: 4,489
no ffriend i search google.but exactely i what ever ii need that data iam not getting.
plz tell me how to solve this issue
Post #1351373
Posted Tuesday, August 28, 2012 11:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 1:33 AM
Points: 4, Visits: 2
Hi Check out Attchement!!

  Post Attachments 
Solution.doc (15 views, 71.00 KB)
Post #1351397
Posted Wednesday, August 29, 2012 12:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:12 AM
Points: 13,271, Visits: 10,149
sameer.kambli (8/28/2012)
Hi Check out Attchement!!


What does this have to do with the schema.ini and the OLE DB Text driver you mentioned earlier?

@asranantha: schema.ini and the JET OLE DB provider allow you to write a SQL query against a flat file. You could write for example SELECT * FROM myFile.

ps: there's a spell check button. Please use it. It will make it easier for other people to understand your questions.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1351401
Posted Wednesday, August 29, 2012 1:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 29, 2012 1:33 AM
Points: 4, Visits: 2
Actually I didn't read the problem carefully!! Sorry for troubling!!

though what i said earlier is not related to SSIS, behind the scenes SSIS uses Schema.ini and OLEDB text driver for reading flat file.
Post #1351438
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse