| Author |
Topic |
|
Rajeev_calling
Starting Member
10 Posts |
 Posted - 2009-10-01 : 10:39:49
|
| I have jsut started working on SSIS pacakge. I am aware of how to create packages or execute stored procedure/query in SSIS package using BIDS.One of my task is to read a flat file(in format say abcdef ghijkl) and then call a stored proc based on the parameters from teh flat file..i.e it should be like exec stored-prc @abc,@def (this is for first row)for second row call shuld be exec stored-proc @ghi,@jklIt would be really very helpful if you please provide som pictorial to complete above tasks. I am using Business Intelligence development studio tool.Thanks a ton in advance for your help!!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 15:27:03
|
| is the data in flat file separated by any delimiter? |
 |
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-03 : 05:13:04
|
| Wel not really.As of now it is in format abcdefghijklmnopqrstso may be need to substring data for each row.But may be i can have data with delimiter as well. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-03 : 14:30:16
|
| how will you know beginning and end of each param value |
|
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-05 : 04:13:40
|
| each parameter in a row is of fixed length. |
|
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-05 : 04:15:04
|
| can you please help me out?? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-05 : 14:23:10
|
quote:
Originally posted by Rajeev_calling
each parameter in a row is of fixed length.
will it be same always? |
|
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-06 : 03:54:45
|
| yes , length will be same always... |
|
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-06 : 06:30:54
|
| this is something very urgent,if you have doen this before , it would be helpful if you can share some doc or something. I didn't find exactly the same thing anywhere on net.... Thanks! |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-10-06 : 16:37:26
|
| load text file to a table and then create a dynamic query to fetch fields from table and run the SP |
|
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-07 : 00:34:40
|
| do i need to make some temporary table and if yes can you please let me know the process of creating table and to stored record from text file in it? |
|
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-10-07 : 09:00:54
|
| Do i need to make temp table in database and how will i substring data of flat file?can you please provide me some document related to my requirement? |
|
|
|
|
Need Urgernt help --may be minor query for u guys