?
Solved

open ssis on vs2005

Posted on 2009-12-19
8
Medium Priority
?
291 Views
Last Modified: 2013-11-10
hi,

I am new to ssis.

I migrated a few dts from 2000 to 2008. I dont have vs2008.  my question is, what is the step by step to open ssis from vs2005?  thx
0
Comment
Question by:mcrmg
  • 4
  • 4
8 Comments
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26086518
go to :
start
programs
microsoft sql server 2005 or 2008
Business Intelligence Development Studio
create new project of template Integration Service Project
after creation of package, add new existing package from sql server store or file system

0
 

Author Comment

by:mcrmg
ID: 26090501
I checked mine, I dont have that..maybe mine is not a full version.  If I want to buy, whch veriosn I should buy so I can work on ssis?  thx
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26090518
It is depend on your sql server version
It must be Standard , Enterprise , Developer edition not SQL Express edition
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mcrmg
ID: 26090595
I have 2008 std on a 64bit box. So, should I buy vs2008 pro?  Thx
0
 
LVL 30

Accepted Solution

by:
Reza Rad earned 2000 total points
ID: 26090636
I think yes, you need VS2008
0
 

Author Comment

by:mcrmg
ID: 26112596
okay, I got the vs2008, where can I find Business Intelligence Development Studio?  thx
0
 

Author Comment

by:mcrmg
ID: 26113608
please help...thx
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26120611
after installation of vs2008 you will see BIDS under: start->programs->microsoft sql server 2008
you can also open BIDS in this manner:
open vs2008 from : start->programs->microsoft visual studio 2008
then create new project
Business Intelligence projects in left panel
in right you can select BI projects like Integration Service Projects
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

616 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