Viewing 15 posts - 16 through 30 (of 46 total)
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...
September 3, 2008 at 1:15 pm
Thanks..........i did not understand what the .dun connection is.dail up network file
September 3, 2008 at 9:18 am
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...
September 2, 2008 at 5:51 pm
i checked running it in SSMS ,i am able to get 11 columns.
SET FMTONLY OFF is present
September 2, 2008 at 4:21 pm
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...
September 2, 2008 at 3:03 pm
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] ?
August 26, 2008 at 7:28 pm
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...
August 26, 2008 at 12:57 pm
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...
August 26, 2008 at 12:31 pm
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...
August 19, 2008 at 10:40 am
no its not working even if i give double '/'
character
\\\hbdk34nb66ml\\folder\\data
August 15, 2008 at 8:46 am
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...
August 14, 2008 at 5:56 pm
covering index may be a form of composite index................what does it mean but sequential index
May 6, 2008 at 2:13 pm
Viewing 15 posts - 16 through 30 (of 46 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy