I have 2 sources in data flow.
output from first source : Abc 1
Output from second source : Abc 2
I want the result set as Abc 1 Abc 2 using ssis.
View Complete Post
I got this result
I have a stored proc which gives me 5 resultsets.
I want to store these in a flat file.
all the result set columns are different.
How can i store all these results into a single file in SSIS.??
sample resultset columns::
date name id value
date name id percentage
date name id totalvalue
date name duration
I have a very simple LocationHierarchy table with ID, ParentLocationHierarchyID, Name columns.
The proc below produces the exact output I want but I want to create a result set that I can pull into a datatable or whatever.
How do I do this? Adding a simple select where the print command is simply creates a result set for each row. Not what I want.
I imagine using some sort of Temp Table might work, but do not know how to impliment it.
Thank you for your help
ALTER PROC dbo.ShowHierarchy
SET NOCOUNT ON
DECLARE @ID int, @Name varchar(30)
SET @Name = (SELECT Name FROM dbo.LocationHierarchy WHERE ID = @Root)
PRINT Cast(@Root as Varchar) + ' - ' + (REPLICATE('-', @@NESTLEVEL * 2) + @Name)
SET @ID = (SELECT MIN(ID) FROM dbo.LocationHierarchy WHERE ParentLocationHierarchyID = @Root)
WHILE @ID IS NOT NULL
EXEC dbo.ShowHierarchy @ID, @MaxLevel
SET @ID = (SELECT MIN(ID) FROM dbo.LocationHierarchy WHERE ParentLocationHierarchyID = @Root AND ID > @ID)
Hi friends, I am trying to combine two rows into one. Read till the end for more information
This is the query used.
'SELECT AA.BILACCT_K, AA.LOCATN_K,DD.INSP_RSLT_SEQ_NB, AA.FWO_SEQ_NB, AA.CTY_CLR_SEQ_NB, AA.ORDR_SBRD_TYP_C, AA.ORDR_TYP_C, CC.TRKG_DESCRIPTOR_T, BB.CTY_CLRNC_STRT_D,
CC.CURRENT_SCHD_D, CC.ORIG_SCHD_D, CC.TRKG_LOCTN_PRNT_C, CC.TRKG_LOCTN_RCV_D, DD.INSP_RSLT_D
I'm hoping someone can provide some insight into a problem I'm having.
I have been tasked with trying to find a way to create multiple sites within the same site collection with a standard Task list in each site. Now, I'd like to combine each of those task lists into one single task list viewable by the managers.
I know I can create a dataview, however I haven't been able to get that view into Outlook using the "Connect to Outlook" option in the Actions Menu of a task list.
Is there a way this can be done?
Any help is appreciated.
i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset
like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid as a compact data and combination of 3 tables from d single dataset.....
can some1 help me please.....
i am developed on simple user registeration application in that i gave address field .when i am trying to enter something like this (1st main,b'lore) but wont take while inserting.
my query is
sqlcommand cmd=new sqlcommand("insert into registeration_form(name,address)values('"+txtname.text+"','"+txt_address+"')",con);
how can i pass the quotes also to my query please if any one know reply me.
This article discusses the Project Linker tool and other techniques to create applications that target both WPF and Silverlight from a single code base.
Erwin van der Valk
MSDN Magazine August 2009
This month we begin a look at the Single Page Interface (SPI) model and some design patterns for designing AJAX applications.
MSDN Magazine May 2008
Use Active Directory Federation Services to allow other organizations to use your Web applications without the need for you to grant access explicitly.
MSDN Magazine November 2006
In this article, Niels Flensted-Jensen demonstrates how you can combine new and existing Microsoft technologies with minimal new code to provide flexible authorization for individual Web service methods. Windows 2003 Authorization Manager, Web Service Enhancements 3.0, and Enterprise Library all play a part.
MSDN Magazine November 2005