RE: How to handle DTS package when upgrade from sql server 2000 to

Hi Charles,

I installed sql server 2005 standard edition. It seems
ok though it took me while. Business Intelligence Development Studio is in
the clients tool.
I looked at your link, a lot of information.
the following link
http://www.microsoft.com/downloads/details.aspx?FamilyID=308C5631-F196-4B00-9320-DEC1FDA8BB0C&displaylang=en
is most helpful. I like video demo, very straitforward.
thank you so much for your great help.

Betty


"c676228" wrote:

Hi Charles,
Please bear with me and I am new to sql server 2005.
Currently I have sql server 2005 upgrade advisor on my personal computer. So
I need to
install sql server 2005 standard edition on my personal computer in order
to develop a ssis package, right?(of course, I will ask dba to install the
SSIS service on our remote database server)
Does that mean after I instal sql server 2005 standard edition, when I open
visual studio 2005, I can see Business Intelligence Projects? I just don't
know what software I should have then I can see Business Intelligence
Projects in Microsoft Visual Studio 2005.

If I installed certain .net start kits which have sql server 2005 express
edition included in the start kits, will it impact on my installation of sql
server 2005 standard edition?

thanks.
--
Betty


"Charles Wang[MSFT]" wrote:

Hi Betty,
SSIS component is included in SQL Server 2005 Standard Edition and
Enterprise Edition. If you want to develop a SSIS package, you should also
install the SSIS service on your server. After that, you can find a project
type named "Integration Services Project" under "Business Intelligence
Projects" in your Visual Studio 2005 project wizard.

Since there are many contents regarding SSIS, it is hard to explain it in a
detail view. There are many video resources in the article mentioned in my
last response. I strongly recommend that you first study them. If you
encounter any issue when you design your packages, please post it here. I
am very glad to work with you for further assistance.

For your study, I also include the following contents for your reference:
Creating a Basic Package Using a Wizard
http://technet.microsoft.com/en-us/library/ms365330.aspx
Creating Packages in SSIS Designer
http://technet.microsoft.com/en-us/library/ms141711.aspx

Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================




.

Relevant Pages
Loading