.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

Combine the mutlple result into single in ssis

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

Hi,

 

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.

 

Thanks,

JR




View Complete Post


More Related Resource Links

SSIS job not giving result required

  
Could someone help us with the Job scheduler on server A.  We are seeing that the jobs say they are running successfully but no data is loading.  For your review, the Catalog_load2 job runs daily.  It truncates the data in the SL_Staging.catalog table then loads the table with data from a file.    On 8/30/2010 7am we get the following message from the job history. Message Executed as user: FED\$svc-SQLsvc. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 100 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 100   DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1   DTSRun:  Package execution complete.  Process Exit Code 0.  The step succeeded.     On 8/31/2010 7am we get a different message Message Executed as user: FED\$svc-SQLsvc. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun:  Package execution complete.  Process Exit Code 0.  The step succeeded. After reviewing the data, no new data is loading.     Now when I manually delete the catalog table records and r

SSIS job not giving result required

  
Could someone help us with the Job scheduler on server A.  We are seeing that the jobs say they are running successfully but no data is loading.  For your review, the Catalog_load2 job runs daily.  It truncates the data in the SL_Staging.catalog table then loads the table with data from a file.    On 8/30/2010 7am we get the following message from the job history. Message Executed as user: FED\$svc-SQLsvc. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 100 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 100   DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1   DTSRun:  Package execution complete.  Process Exit Code 0.  The step succeeded.     On 8/31/2010 7am we get a different message Message Executed as user: FED\$svc-SQLsvc. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun:  Package execution complete.  Process Exit Code 0.  The step succeeded. After reviewing the data, no new data is loading.     Now when I manually delete the catalog table records and r

calling web service from SSIS return result as null

  

Hello,

I got this result

<Result>The result is null. Either the result is null or the Web method returns void.</Result> 
 when I calling web service from SSIS. I setup HTTP connection and tested without any problem; download WSDL without any problem; I did exactly as the link: http://msdn.microsoft.com/en-us/library/ms181267.aspx. From input editor, I selected service and method. For the chosen method, there will be 3 variables (1 input parameter, 2 output parameters). For the input variable, I defined the package variable as string, and copied XML content to the variable as the value. I will select this defined package variable as the input parameter. I then moved to defined output file.
 
 When I run the simple package, I will get the output file as result as above. What is wron

Multiple result set to a single text file

  

HI

 

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

date  name   id    value

date  name   id    percentage

date  name  id     totalvalue

date  name  duration

 

Thanks

 


Single Result Set from Recursive Query

  

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

Earl

 

 

ALTER PROC dbo.ShowHierarchy
(
 @Root int,
 @MaxLevel int
)
AS
BEGIN
 SET NOCOUNT ON
 DECLARE @ID int, @Name varchar(30)

 SET @Name = (SELECT Name FROM dbo.LocationHierarchy WHERE ID = @Root)
 
  IF @@NESTLEVEL<@MaxLevel
  BEGIN 
   PRINT Cast(@Root as Varchar) + ' - ' + (REPLICATE('-', @@NESTLEVEL * 2) + @Name)
  END
 SET @ID = (SELECT MIN(ID) FROM dbo.LocationHierarchy WHERE ParentLocationHierarchyID = @Root)

 WHILE @ID IS NOT NULL
 BEGIN
   EXEC dbo.ShowHierarchy @ID, @MaxLevel
   SET @ID = (SELECT MIN(ID) FROM dbo.LocationHierarchy WHERE ParentLocationHierarchyID = @Root AND ID > @ID)
 END

Trying to combine two rows into one result set

  

Hi friends, I am trying to combine two rows into one.  Read till the end for more information

This is the query used.

SELECT * FROM OPENQUERY( DB2UREMOTE, '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

FROM F0DB2U.TFW

How to combine multiple task lists on multiple sites into single task list which then connects to Ou

  

Hi,

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.



Application Architecture in Windows Forms 2.0-Single-MDI Applications

  
Consider an MDI application like Microsoft Excel; files opened from the file system (by double-clicking) are all opened as separate child windows within the parent Excel window.7 For the first instance of an MDI application to open a new child window to display the file that was passed to the second instance of the application, the second instance must be able to communicate with the initial instance.

Combine, minify and compress JavaScript files to load ASP.NET pages faster

  
Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

merging multiple tables in a single dataset to single table

  

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


how To Insert the single quotes in sqlcommand in asp.net

  

Hi all

    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.


Thanks

G Dinakaran



Active Directory and .NET: paging the search result

  
Hi everybody!

I have a question about Active Directory in .NET
For my project I need to fetch results from Active Directory search page by page, because later I would need to bind it to the pageable DataGrid.

I tried to use .NET library DirectoryServices for that, but paging provided by this library is transparent to the user and is used only to increase the efficiency of searching, when results are too big. I.e. I cannot tell the DirectorySearcher to give me first page, then the next or previous page, it returns me all resulting pages in one bundle.

However, what I need is to explicitely get page after page directly from the AD searcher and to be able to go at least one page forward or backward.

The solution with copying all results to the DataBase and then do the paging is not accepeted by the clent, since it is too inefficient. And since it's a Web app, I cannot keep results in memory either.

I found some hints about COM Interface, but I could not find good and detailed examples or explanations. I aslo found this line of code: DirectoryServices.Interop.IDirectorySearch.ExecuteSearch(), but I don't know which libraries should i add to be able to compile this code.

If somebody could help me out with that problem, any suggestion is welcome, 'cause this issue is eating me alive :)

Thank you!

Inside Microsoft patterns & practices: Building WPF and Silverlight Applications with a Single Code

  

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


Cutting Edge: Single-page Interface and AJAX Patterns

  

This month we begin a look at the Single Page Interface (SPI) model and some design patterns for designing AJAX applications.

Dino Esposito

MSDN Magazine May 2008


Single Sign-On: A Developer's Introduction To Active Directory Federation Services

  

Use Active Directory Federation Services to allow other organizations to use your Web applications without the need for you to grant access explicitly.

Keith Brown

MSDN Magazine November 2006


What Gives You the Right?: Combine the Powers of AzMan and WSE 3.0 to Protect Your Web Services

  

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.

Niels Flensted-Jensen

MSDN Magazine November 2005


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend