bug: name change of connection manager is not propogated through package

create a package with a connection manager

reference the manager with a bunch of tasks

change the name of the manager

stand back in disbelief as you receive the following message

Error: 0xC004800B at Data Flow Task, DTS.Pipeline: Cannot find the connection manager with ID "SourceConnectionExcel" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "runtime connection "OleDbConnection" (8)" in the connection manager collection of "component "Source - 'DCD MANUAL$'" (1)". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.

SSIS? SSUX

What version of SSIS are you using? RTM? SP1? SP2?

I rename connection managers all of the time and never have a problem. SP1 and SP2 depending on which machine I'm on.

|||

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Microsoft SQL Server Integration Services Designer
Version 9.00.3042.00

|||

You probably generated your package using the Import/Export wizard. The wizard use to reference connection managers in sources and destinations using the names instead of IDs. That would work better if you copy both componets and connections to another package but breaks when you try to rename connection managers.

The problem should be easy to correct: just open the component UI and select the connection again. Feel free to open a bug on the connect site as well.

Thanks,

Bob

bring online - any restrictions?

Hiya,
Are there any conditions under which a database administrator is not able to
bring a database back online when it is (Suspect\offline)? The System Admin
istrator had no problem bringing it back online but the usual dba got a perm
issions error.
Thanks!I have had that occur a few times for no apparent reason. I think it is rela
ted to the reason that it went offline in the first place.|||Just verify that this dba has the necessary perimissions to this database.
If this dba is the dbo of the database or is a member of the sysadmin role
there should be no problem.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Bring db online/offline

Hello there,

I have a user who can bring offline a database but he cannot bring the
database back online.

The error which pops up is:

Error5011: User does not have permission to alter database dbname
ALTER DATABASE statement failed.
sp_dboption command failed.

Any ideas?

ThanksI would guess that only sysadmins can bring a database online, because
if the database is not readable, there's no way to know who has
db_owner permissions. This behaviour is documented for RESTORE - a
db_owner can backup a database but not restore it - and it seems likely
that the same logic applies in the case of ALTER DATABASE, even if it
isn't documented.

Depending on what you're trying to achieve, setting the database to
RESTRICTED_USER might be a possibility.

Simon

Bring back Query Analyser

Hi,
I am using 2005 SQL Management to edit my T-SQL stuff but it reformats all
of my SQL statements (just like Enterprise Manager) making complex
statements impossible to read.
Can anyone tell me if there any options to turn this off and/or an
alternative?
Thanks for any help,
Steve.I am using 2K5 SQL Management, your problem doesn't occur at my site.
Do you use query builder?
Steve Lloyd wrote:
> Hi,
> I am using 2005 SQL Management to edit my T-SQL stuff but it reformats all
> of my SQL statements (just like Enterprise Manager) making complex
> statements impossible to read.
> Can anyone tell me if there any options to turn this off and/or an
> alternative?
> Thanks for any help,
> Steve.|||Hi, thanks for the reply,
Ok, find out a few more things... Stored procedures open using query builder
and I can retain the formatting but Views open Enterpise Manager style and I
can't work out how to stop it...
Thanks again
Steve
<navyzhu@.gmail.com> wrote in message
news:1149757541.865478.194360@.h76g2000cwa.googlegroups.com...
>I am using 2K5 SQL Management, your problem doesn't occur at my site.
> Do you use query builder?
> Steve Lloyd wrote:
>|||Steve Lloyd (steve.remove@.livenowpaylater.this.co.uk) writes:
> Ok, find out a few more things... Stored procedures open using query
> builder and I can retain the formatting but Views open Enterpise Manager
> style and I can't work out how to stop it...
Stop using the Query Designer.
After all, since the subject line says bring back "Query Analyzer", you
should be used to be without the Query Designer as it is not present in
Query Analyzer.
As long as you stick to the regular query editor in Mgmt Studio, there
should be no reformatting.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||In addition to Erland's post:
Keep your DDL scripts somewhere safe, and only use them to create/alter/drop
SQL objects.
ML
http://milambda.blogspot.com/|||OK, it think I'm not making myself clear.. I want to be able to edit my
Views, Query Analyzer style, but when I open them in SQL Management they
default to the Query Builder and I can't work out how to open them without.
Sorry for the confusion...
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns97DC7DAD2FAEBYazorman@.127.0.0.1...
> Steve Lloyd (steve.remove@.livenowpaylater.this.co.uk) writes:
> Stop using the Query Designer.
> After all, since the subject line says bring back "Query Analyzer", you
> should be used to be without the Query Designer as it is not present in
> Query Analyzer.
> As long as you stick to the regular query editor in Mgmt Studio, there
> should be no reformatting.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx|||Right click on the view
DO NOT select modify view
Instead choose Script View as -->ALTER To--> New Query window
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Steve Lloyd wrote:
> OK, it think I'm not making myself clear.. I want to be able to edit my
> Views, Query Analyzer style, but when I open them in SQL Management they
> default to the Query Builder and I can't work out how to open them without
.
> Sorry for the confusion...
> "Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
> news:Xns97DC7DAD2FAEBYazorman@.127.0.0.1...|||> Right click on the view
> DO NOT select modify view
> Instead choose Script View as -->ALTER To--> New Query window
This is easily in my top ten of pet peeves in Management Studio. Not just
because Modify does this weird thing with a useless Access-style view
designer that drives me bonkers, but combined with the slowness and the
frequency that I click the wrong menu item, it is maddening.
I was told off the cuff that they're going to add some options to the
immediate right-click menu for views, but I don't know when they'll be
implemented...

Bring back excluded item

Hi all,

I have been wrestling with this problem all morning with no success so
far where I have a need to bring back an excluded field.

Basically I have a list of order numbers. Each order number can have
many order types attached one of which is a P type. Most order types
have an account number attached in its own field however when a P type
is selected the account number is not brought back.

Is there someway I can get this brought back for each P type or do I
have to do some fancy insert in a data warehouse to get this done (i.e.
insert account numbers into all P types)?

Many thanks

Sam

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Please post DDL (CREATE TABLE statements, including the relevant columns,
keys and constraints) for these tables, post a few rows of sample data as
INSERT statements and show your required result. That way it's much easier
for others to understand and solve your problem.

--
David Portas
----
Please reply only to the newsgroup
--

Bring a table back

Hello, everyone:

I have deleted a static table accidentally in production. How will I bring it back? Thanks a lot.
ZYTOriginally posted by yitongzhang
Hello, everyone:

I have deleted a static table accidentally in production. How will I bring it back? Thanks a lot.

ZYT
:eek: Got any backups??|||Originally posted by yitongzhang
Hello, everyone:

I have deleted a static table accidentally in production. How will I bring it back? Thanks a lot.

ZYT

Restoring it from a nightly backup is the only way I can think of getting it back. Hopefully since it was in production you have some backups ;)

breaking web service?

I currently have a SQL 2000 RS SP2 installation and upgraded the back end to
2005. I think I read somewhere that the web service is not compatible
anymore? I am using the web services and don't want to have to change any
code if I don't have to. Will my 2000 WS implementation continue to work
after I install SSRS 2005?
Thanks
ScottHi Scott,
As for the SQL Server reporting service, the webservice interface should
definitely change from version 2000 to version 2005 as Reporting service
2005 has involved some new objects and methods signatures. A simple way to
check this is compare the WSDL service description of the two ones and look
for the service interface definiations. If you want to migrate your
application from RS 2000 to RS 2005, I think it is necessary to regenerate
the service proxy and use the new proxy methods.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Breaking a SQL Cluster

Is there a way to break my Active/Active cluster back to have a single
stand-alone SQL server?
internal politics and a rogue admin who applies security patches willie
nillie to the cluster nodes is causing more downtime than the cluster is
worth!
Hopefully there is a way that this can be done fairly painlessly.
Thanks in advance,
Ron G
You can uninstall a virtual server by running the installation wizard again.
The books online have the exact steps listed.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Ron Griffin" <rgriffin@.lattestonetech.com> wrote in message
news:8A9Zd.19191$YD4.2485@.newssvr12.news.prodigy.c om...
> Is there a way to break my Active/Active cluster back to have a single
> stand-alone SQL server?
> internal politics and a rogue admin who applies security patches willie
> nillie to the cluster nodes is causing more downtime than the cluster is
> worth!
> Hopefully there is a way that this can be done fairly painlessly.
> Thanks in advance,
> Ron G
>