SolvedPrivate

ssis package

Posted on 2013-06-08
2
22 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
ID: 39233045
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
ID: 39233529
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

803 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