Bug Report: Expressions not deleted

I've noticed that if you create a data flow task (such as a DataReader source) and then bind an expression to it, if you rename or delete the task the expressions bound to the task will disappear but still be in the DTSX itself. So, if your expressions stop parsing (if you remove a variable, etc.) you will get errors for these expressions which you thought should have been removed. The workaround is to re-add the tasks with the old names and go delete the expressions from the expression list.
I suggest you raise a bug at http://lab.msdn.microsoft.com/ProductFeedback|||I could reproduce this problem and filed a bug.

BUG in SQL Server Manager - Default Schema

Hallo,
June CTP of SQL Server 2005 (NOT SQL Express)
########
Everything deleted from this post by Alle since it has no relevance to the RTM.
Unfortunately I can not delete the thread.
###########
Alle

There is now an invisible comment that has been added by a moderator (I hate that too, why isn't the comment / edit visible in the thread?) :

=== Edited by Paul Mestemaker - MSFT @. 28 Oct 2006 1:59 AM UTC===
This is a comment not a question. This bug has been fixed.

Paul,

you are absolutely right, it was fixed ages ago and in addition we are well over the CTP stage of SQL Server 2005 which was RTM one year ago.

Wouldn't it make much more sense to delete this entire thread since it now longer has ANY revelance?

I can't although I am the author (I tried).

Thanks,
Alle

BUG in SQL Server Manager - Default Schema

Hallo,
June CTP of SQL Server 2005 (NOT SQL Express)
########
Everything deleted from this post by Alle since it has no relevance to the RTM.
Unfortunately I can not delete the thread.
###########
Alle

There is now an invisible comment that has been added by a moderator (I hate that too, why isn't the comment / edit visible in the thread?) :

=== Edited by Paul Mestemaker - MSFT @. 28 Oct 2006 1:59 AM UTC===
This is a comment not a question. This bug has been fixed.

Paul,

you are absolutely right, it was fixed ages ago and in addition we are well over the CTP stage of SQL Server 2005 which was RTM one year ago.

Wouldn't it make much more sense to delete this entire thread since it now longer has ANY revelance?

I can't although I am the author (I tried).

Thanks,
Alle

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 ;)

BPA Install Problem

I'm installing the latest version of BPA and seem to have run into an issue.
I've uninstalled the app and deleted the old BPA database, and while
reinstalling, I'm seeing an error message come up. "One or more rules could
not be installed. There is an error in XML document (55, 15). Invalid SQL
Server edition."
I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
Where can I start to look to debug this problem?
Steve
Please uninstall and reinstall, but before reinstalling make sure that the
destination folder is empty. At the very least you should make sure that
bpadmin.exe.config file doesn not exist, and that no files or folders are
left under repository folder.
Let me know if that doesn't work.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I'm installing the latest version of BPA and seem to have run into an
issue.
> I've uninstalled the app and deleted the old BPA database, and while
> reinstalling, I'm seeing an error message come up. "One or more rules
could
> not be installed. There is an error in XML document (55, 15). Invalid
SQL
> Server edition."
> I'm running everything locally, and running SQL 2k, SP3 on WinXP SP1
> Where can I start to look to debug this problem?
>
|||Well,
Its apparent that I'm a database guy and not an application guy!
That worked like a charm. Thanks!
BTW... great app!
-Steve
"Christian Kleinerman [MS]" <ckleiner@.online.microsoft.com> wrote in message
news:e870CqYTEHA.2324@.TK2MSFTNGP10.phx.gbl...
> Steve
> Please uninstall and reinstall, but before reinstalling make sure that the
> destination folder is empty. At the very least you should make sure that
> bpadmin.exe.config file doesn not exist, and that no files or folders are
> left under repository folder.
> Let me know if that doesn't work.
> - Christian
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Steve Carroll" <steve_carroll72@.h_o_t_m_a_i_l.com> wrote in message
> news:uELb%23aYTEHA.2908@.TK2MSFTNGP10.phx.gbl...
> issue.
> could
> SQL
>