August 27, 2012 at 7:30 am
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
August 27, 2012 at 1:50 pm
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.
August 27, 2012 at 9:12 pm
its load data different table
August 27, 2012 at 9:27 pm
asranantha (8/27/2012)
hi friend i have a small doubt in ssis plz tell me how to solve this proball 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 ...
August 27, 2012 at 10:13 pm
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?
August 28, 2012 at 3:17 am
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!!
August 28, 2012 at 9:04 pm
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
August 28, 2012 at 11:48 pm
Hi Check out Attchement!!
August 29, 2012 at 12:02 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 29, 2012 at 1:38 am
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.
August 29, 2012 at 1:44 am
sameer.kambli (8/29/2012)
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.
Do you have any resource for that?
As far as I know, the OLE DB Text driver relies on JET, which is 32-bit only.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 29, 2012 at 1:49 am
Search MSDN online for Schema.ini and OLEDB Text Driver!!
August 29, 2012 at 1:59 am
sameer.kambli (8/29/2012)
Search MSDN online for Schema.ini and OLEDB Text Driver!!
I did. Nothing pops up.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply