Re: Missing Templates for Integration Services

#1

Here are a few ideas about where to look to convert packages

http://wiki.sqlis.com/default.aspx/S...ionWizard.html

http://wiki.sqlis.com/default.aspx/S...zardSteps.html

Integration Services projects are found in BIDS

Start | Run | Devenv

--

Regards

Allan Mitchell

Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"AOTX San Antonio" <ElTejano (AT) newsgroups (DOT) nospam.nospam> wrote

Quote:

When installing Sql Server 2005 I also installed Integration Services
(SSIS).
I have been able to import all my DTS packages into the Integration
Services
MSDB folder. I wanted to learn a little more about SSIS so I could
convert my
DTS packages to take advantage of the new tool. After reading several
articles I decided to creat a new project and attemp to convert one of
my old
DTS packages. Under file I selected "New Project". When the New Project
window opens I only see three Templates : Sql Server Scripts, Analysis
Services Scripts, and SQL Mobile Scripts, but nothing for Integration
Services. Did I miss something on the installation or is there another
problem. Question is how do I go about getting the proper Template(s)
for
SSIS...

Thanks

#2

Start | Run | devenv | File | New Project

You should see at the top "Business Intelligence Projects" highight
that and you should see "Integration Services Project" in the right hand
side panel

--

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"AOTX San Antonio" <ElTejano (AT) newsgroups (DOT) nospam.nospam> wrote

Quote:

Thanks Allen for your response...

My problem is not importing DTS packages into SSIS it is the ability to
create a new project in SSIS. When I open a new project I do not see the
SSIS
templates needed to create an SSIS Project....

"Allan Mitchell" wrote:

Here are a few ideas about where to look to convert packages

http://wiki.sqlis.com/default.aspx/S...hePackageMigra
tionWizard.html

http://wiki.sqlis.com/default.aspx/S...zardSteps.html

Integration Services projects are found in BIDS

Start | Run | Devenv

--

Regards

Allan Mitchell

Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"AOTX San Antonio" <ElTejano (AT) newsgroups (DOT) nospam.nospam> wrote in
message
news:8E9EDCB0-F539-4DA2-AD97-7B7F1C4E894B (AT) microsoft (DOT) com:

When installing Sql Server 2005 I also installed Integration
Services
(SSIS).
I have been able to import all my DTS packages into the Integration
Services
MSDB folder. I wanted to learn a little more about SSIS so I could
convert my
DTS packages to take advantage of the new tool. After reading
several
articles I decided to creat a new project and attemp to convert one
of
my old
DTS packages. Under file I selected "New Project". When the New
Project
window opens I only see three Templates : Sql Server Scripts,
Analysis
Services Scripts, and SQL Mobile Scripts, but nothing for
Integration
Services. Did I miss something on the installation or is there
another
problem. Question is how do I go about getting the proper
Template(s)
for
SSIS...

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Missing Templates for Integration Services

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Missing Templates for Integration Services - 12-22-2006 , 04:43 AM

Re: Missing Templates for Integration Services - 12-22-2006 , 03:55 PM