Question is, when will Microsoft provide seamless portability for SSIS pkg's? I thought it would be available by now but apparently not. Unless someone knows the trick (read...

Has anyone seen SSIS pkg portability (from Server A to Server B) work properly using the following design? Steps I used:

FYI: Server "A" resides in our Development environment;...

There's an issue w/ Child packages.

When you deploy an SSIS package to a new server in SQL Server 2005 Service Pack 1, you receive an error message that...

Thanks so much for your reply. FYI, I found a pretty decent Microsoft transcipt on MIRRORING questions & answers:

http://www.microsoft.com/technet/community/chats/trans/sql/sql_102704.mspx ? many questions/answers here

Modified to: SELECT CAST((Col_1 / Col_2) as DECIMAL(9,5))

Worked like a champ.

thx Noel.. much appreciated. A further description on this is located here:

How to: Allow Non-Administrators to Use Replication Monitor (Replication Transact-SQL Programming)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/repref9/html/a3bdde8f-4f90-401f-b26a-dfe803534de7.htm

Noel - thx for the feedback. Just wanted to make sure I read this correctly.

(Are you sure Microsoft didn't do this to catch up w/ DB2 and...

We noticed that SQL 2000 SP4 retunrs same result as SQL 2005. BUT---- SQL 2000 SP3 (and less) return the different result set.

How would I code the sp_trace_setfilter statement to filter on DATABASE ID = 5  ??

I cannot get a SQL Profiler trace, dumping to a SQL 2005 table, to run on our new SQL SERVER 2005 environment.  I continually receive the error msg "Failed to start...

Another cmd:

select * from sys.traces

SELECT * FROM fn_trace_getinfo(0)

Interesting.  I do have a trace running.. (E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_16.trc)  as per:

http://sqljunkies.com/WebLog/outerjoin/archive/2005/10/16/17157.aspx

To stop the MS SS2005 default trace, I ran:

sp_configure 'default trace enabled', 0

RECONFIGURE

Question is -- Can't...

OK Ray - I think I have a crude, work-around.  Essentially, using the dynamic SQL you've supplied, I generate a "real" table housing my TableNames sourced from sysobjects.  I then...

Ray - still at a roadblock --The functionality should allow the user to select a DatabaseName for a pre-populated dropdown. (this works fine). Subsequently, via a cascading parameter in RS...