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...

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

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...

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

SET FMTONLY OFF is present

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...

thanks a lot

Create function [dbo].[ResultSet]

(

@ID int

)

returns @TempResult table (a,b,c,d)

as

Begin

insert @tempresult

select @a,@b,@c ,@d

end

return

end

this is the structure of the function

In OLEDB source i used like

select * from [dbo].[ResultSet] ?

alter PROCEDURE [dbo].[ResultSet] @ID int

AS

create Table #TempResult

(,,,,,,)

Insert into #TempResult

EXEC [dbo].[Retrivefields] @ID

select * from #TempResult

Drop Table #TempResult

I used in the data flow EXEC [dbo].[RetriveResultSet] 508

but it is not showing columns in...

thanks for ur response.

Actualy that is not my SP.I have to retrive some columns (8)and the query contain many join which is taking long time to run.So what i did...

thanks a lot ...................if i need to run the package in production server i need to add the server name in the package as i need to schedule a job...

no its not working even if i give double '/'

character

\\\hbdk34nb66ml\\folder\\data

instead of getting the .out file from C:\path i would like pull that from \\b23jksl0sdhnw\data.....i would like to provide this path.We declare a string and assign this path to the...

thanks for you response

Thanku.......they asked me in one interview

covering index may be a form of composite index................what does it mean but sequential index