Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS questions?

Posted on 2012-03-28
3
Medium Priority
?
703 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 268 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 264 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 268 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

783 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