I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..
How can I make it visible in the New Project window?
I have successfully used the import function so I think this means
that Inegration Services is there somewhere.
I would appreciate some advice,
Best wishes, John Morgan
3  1727 
John Morgan wrote:
I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..
How can I make it visible in the New Project window?
I have successfully used the import function so I think this means
that Inegration Services is there somewhere.
I would appreciate some advice,
Best wishes, John Morgan
What version of 2005 are you using?
John Morgan (jf*@XXwoodland er.co.uk) writes:
I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..
How can I make it visible in the New Project window?
I have successfully used the import function so I think this means
that Inegration Services is there somewhere.
I believe the place to work with Integrations Services is the
Business Intelligence Development Studio.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Thanks both of you. Using your info and investigating the matter
further to make sure I don't hask silly questions has got me the
answer.
I checked the configuration manager and found that integrated services
was listed as running, I looked again and, yes, I did see SQL
Buisiness iIntelligence Studio was part of the programme group.
Opened it up and the VStudio installed templates for Integration
Services Project were visible.
Thanks
John Morgan
On Sun, 28 Jan 2007 08:24:28 -0600, Jonathan Roberts
<gr*******@diyn ics.comwrote:
>John Morgan wrote:
>I have installed SQL Server Management Studio 2005 and have been
finding the equivalent of the Data Transfer Services in SQLServer
2000. I think I have worked out that it is in SQL Server Integration
Services but when I open File-New-Project I do not see the SQL Server
Integration Services there, though Help assumes that it is available
for selection when starting a new project..
How can I make it visible in the New Project window?
I have successfully used the import function so I think this means
that Inegration Services is there somewhere.
I would appreciate some advice,
Best wishes, John Morgan
What version of 2005 are you using?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: PBsoft |
last post by:
- comp.databases.ms-sqlserver
- microsoft.public.sqlserver.odbc
- microsoft.public.sqlserver.server
I installed "SQL 2005 Express with Advanced Services with SP1" onto two machines
with "Windows XP Pro SP2".
On both computers I noticed that in SSMS Express, under "Server Objects"
-"Linked Servers" -"Providers", the list of providers installed is empty!!!!
|
by: theintrepidfox |
last post by:
Dear Group
I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:
Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)
|
by: Icemokka |
last post by:
Hi,
We have a SQL-cluster with over 6300 databases, most of them pretty
small in size and usage.
For this reason all these databases are on auto-close ( Otherwise SQL
would need many many gigabytes ).
We've recently upgraded to SQL 2005 because of the Management Studio,
because the EM is unusable on a SQL-Server with lots of databases.
|
by: Larry Bertolini |
last post by:
Experiencing a little weirdness with SQL Server Management Studio...
Have created a login, that has fixed server role "securityadmin".
The login can create/drop logins, add/remove them as users in
databases, etc.
The login can change another login's password, using SQL
from a query window (e.g. alter login bob with password='abc')
However, the login *cannot* change another login's password,
|
by: Steve |
last post by:
Hi;
I thought I would rephrase a question I asked in another post to more
quickly get to the heart of the matter. My apologies for anyone who
is offended by what appears to be a repetition.
My company has two identical web sites. One copy is for our customer,
and one copy is for us to test our code changes on.
We developed a hard to isolate bug in the copy of the web stie for our
| | |
by: jc |
last post by:
Hello.
I have a gridview column item that i want to not make visible if the
bound data in that cell is less than a value in a textbox.
However, I notice at the time my code checks a function that I call
from the visible property of the gridview itemtemplate, the textbox is
always blank.
I tried setting the textbox in the prerender, but I suspect the
|
by: Alex Pavluck |
last post by:
Hi. I am managing a SQL server that is running SQL 2005. I really
like the management studio that comes with the full version because I
can view tables and easily create relationships and queries. Is this
same level of control available with the SQL 2008 express edition? I
want to get familiar with the tools and the syntax on my laptop but I
don't want to install a full version.
Thanks!
Alex
|
by: cathy25 |
last post by:
Hi,
we are planning on migrating our sql from version 2000 to 2005 (I know SQL 2005 is in market from a while). As a part of testing, i have installed sql server 2005 on my development box and able to restore all databases from the production. When it came to DTS packages, I have used SSMS to migrate them by going into Management --> Legacy --> Data Transformation Services --> RC and selected Migrate Wizard. I have gone through the wizard and...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
