Problem withFlat File result columns

Question

Problem withFlat File result columns

chinni-652949

Default port

Points: 1425
More actions
September 2, 2008 at 11:44 am

#131008

Hi can any one help me out in this......
OLEDB source is connect to flat file in data flow task..........flat file is retreving only 10 columns but the stored procedure in OLEDB souce has 11 columns as output.
I tried recreating connection manager but did not work
thanks

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Chinna SSCertifiable Points: 5408 More actions · Answer 1

Hi chinni..

Could you just send me that sproc or give me some or details so that we can go further regd the issue...the main thing is u need to map it correctly when ur mapping does it showing 11 columns or 10 tat itself solves ur issue...k then let me know if anything needed...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

chinni-652949 Default port Points: 1425 More actions · Answer 2

Thanks for the response Chinna

Even in mapping its showing only 10 fields...........all these fields in SP recide as temp variables,Initially when I rum the package I have only 9 columns and then i changes SP to 10 columns and recreated connection manager it showd 10 fields later ,I updated SP with 11 columns now and created new connection....but i could not find new column........

Chinna SSCertifiable Points: 5408 More actions · Answer 3

let me check it out is it possible for u to send me the snapshot of ur connections ...and did u check the stored proc by running it in managemnet studio does the output gives u 11 columns check it out if not there would be some problem with the stored proc...

Many users have issues when trying to use a stored procedure in an OLE DB Source component. Here are some tips:

* Ensure that there is a final select statement at the end of the stored procedure to ensure the correct resultset is returned

* At the top of the stored procedure as part of the procedure code, add the following line: SET NOCOUNT ON

* At the top of the OLE DB Source SQL statement and before you issue the EXEC YourSproc line, add the following: SET FMTONLY OFF.

This should ensure that when you click on the column mapping tab, the columns are correctly displayed.

Also another approach is to use a table variable in the stored proc. Then at the end, select from that table variable.

check this out if it doesnt work let me know...and i want to cjeck u in the source itslef jus parse the sp and even see the priview check whther u are getting the correct output ...

if not could u jus send me the sp..

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Chinna SSCertifiable Points: 5408 More actions · Answer 4

I forgot to say u...did u run the sp after making changes to 11 columns in management studio if not run it before u exec in ssis package...i belive that would solve ur problem ...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

chinni-652949 Default port Points: 1425 More actions · Answer 5

i checked running it in SSMS ,i am able to get 11 columns.

SET FMTONLY OFF is present

Chinna SSCertifiable Points: 5408 More actions · Answer 6

how are you passing the parameters

exec usp_abc ?,?,?,?,?,?,?,?,?,?,?,

u need to have 11 commas i guess try this once and let me know

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

chinni-652949 Default port Points: 1425 More actions · Answer 7

thanks a lot....its working now.......i re created data flow task.....

I have one more question.......

I used FTP tp trasfer file from Sql server to mainframe.It doent work.I fould like we can send using batch file .

i created batch file and SCR file like

Open servername

username

passwd

literal site refm=fc lrecl=50 blksize=6000 wraprecord

put C:\Documents and Settings\Desktop\sampleData.txt" ‘RFGT.FTP.HDP.KS.CODML(+1)' (replace

quit

SCR:

ftp -s:"HDPextract.scr" >"resultsHDP.txt"

ECHO Done > "HDPextract.dun"

What about the .dun network connection

i saw some packages which are running in this format.I created the same type of scr and batch file..........but i dont know what to do with this .dun file.........will this work

chinni-652949 Default port Points: 1425 More actions · Answer 8

Thanks..........i did not understand what the .dun connection is.dail up network file

chinni-652949 Default port Points: 1425 More actions · Answer 9

I have a flat file I need to FTP that to mainframes.I tried using FTP task but it did not work.I tried script task its showing error server name not resolved.

Chinna SSCertifiable Points: 5408 More actions · Answer 10

hmm......see the attachment ..

:arrow:feels like a totty ....Take it easy...:P

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

chinni-652949 Default port Points: 1425 More actions · Answer 11

thanks FTP is working.......................i used batch file to transfer..............the script is same as in above post

chinni-652949 Default port Points: 1425 More actions · Answer 12

i did not use FTP task i used batch file................i work from office and if i have anything left out I will work from home tooo

chinni-652949 Default port Points: 1425 More actions · Answer 13

I have a update command just update indicator field to Y,

even i have no fields to update its taking long time around 20 min...the fields need to be updated are zero.......

Thanks

-----------------------------------------------------

where r u from chinna

chinni-652949 Default port Points: 1425 More actions · Answer 14

chinni-652949

Default port

Points: 1425

September 15, 2008 at 10:38 am

#871909

update table

SET Indicator='Y' where id= 1324