SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


ssis flatfile data to database table prob


ssis flatfile data to database table prob

Author
Message
asranantha
asranantha
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1006 Visits: 4717
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
AllaboutSQL
AllaboutSQL
SSC-Enthusiastic
SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)SSC-Enthusiastic (183 reputation)

Group: General Forum Members
Points: 183 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.
asranantha
asranantha
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1006 Visits: 4717
its load data different table
sandeep rawat
sandeep rawat
Right there with Babe
Right there with Babe (797 reputation)Right there with Babe (797 reputation)Right there with Babe (797 reputation)Right there with Babe (797 reputation)Right there with Babe (797 reputation)Right there with Babe (797 reputation)Right there with Babe (797 reputation)Right there with Babe (797 reputation)

Group: General Forum Members
Points: 797 Visits: 376
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 ...
MissTippsInOz
MissTippsInOz
Right there with Babe
Right there with Babe (785 reputation)Right there with Babe (785 reputation)Right there with Babe (785 reputation)Right there with Babe (785 reputation)Right there with Babe (785 reputation)Right there with Babe (785 reputation)Right there with Babe (785 reputation)Right there with Babe (785 reputation)

Group: General Forum Members
Points: 785 Visits: 597
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?
sameer.kambli
sameer.kambli
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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!!
asranantha
asranantha
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1006 Visits: 4717
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
sameer.kambli
sameer.kambli
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 2
Hi Check out Attchement!!
Attachments
Solution.doc (21 views, 71.00 KB)
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: General Forum Members
Points: 61655 Visits: 13297
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
sameer.kambli
sameer.kambli
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search