SolvedPrivate

ssis package

Posted on 2013-06-08
2
21 Views
Last Modified: 2016-02-11
i checked out a package from svn
1. how do i branch it?
2. the package has config for dev, test and prd
 how do i make changes ? i just need to make some changes in one of the sql tasks.

the package
csv file is used to load in database. i need to add a field in the db. also the package is spitting in the oracle db where i need to add a field. how do i connect to oracle db?
0
Comment
Question by:package_monkey
2 Comments
 

Author Comment

by:package_monkey
Comment Utility
my question is
1. i checked out a package from svn. i need to add fields in the table which is being populated from a csv file.the package is populating a table in sql server and also a table in oracle db.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 350 total points
Comment Utility
Hi,

Branching is where there are multiple success paths from one task, and each path has a condition on it.

HTH
  David
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

728 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

15 Experts available now in Live!

Get 1:1 Help Now