Solved

SSIS questions?

Posted on 2012-03-28
3
690 Views
Last Modified: 2012-04-21
We are using MS SQL 2008 R2

1). In SSIS, from input table to look-up table, is it the left join or inner join?

2). Once we create SSIS pakage, how to assign users to run the package?
0
Comment
Question by:wasabi3689
3 Comments
 
LVL 22

Assisted Solution

by:PedroCGD
PedroCGD earned 67 total points
ID: 37779543
1) Left join... the data in the pipeline is the left dataset and the reference dataset is the right side... to use other joins use the Merge Join Transformation.

2) You need to assign the user to SSIS database roles:
Check this link: http://technet.microsoft.com/en-us/library/ms141053.aspx

Helped?
Regards,
Pedro
0
 
LVL 11

Assisted Solution

by:SThaya
SThaya earned 66 total points
ID: 37815563
Look up transformation will check the EXACT match (incomming data with the reference dataset .


Link : http://blogs.msdn.com/b/arali/archive/2009/12/31/lookup-transformation-in-ssis-sql-server-integration-services-2005-and-2008.aspx
0
 
LVL 14

Accepted Solution

by:
nishant joshi earned 67 total points
ID: 37856918
SSIS already having an lookup transformation which is good you can use it easily and it is efficient that merge join transformation.

there are too many ways that user can use this package
1)you can deploy it to your on ssis server
2)you can execute from bi
3)create a job for execution
4)execute with package utility dtutil.exe

Regards.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now