Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SSIS – Transfer SQL Server Objects Debugged Expand / Collapse
Author
Message
Posted Thursday, April 5, 2007 9:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 15, 2012 6:47 PM
Points: 8, Visits: 36
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/sLaPlante/2955.asp
Post #356293
Posted Thursday, April 5, 2007 10:28 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 5:10 PM
Points: 275, Visits: 168
Thanks Steve, this was helpful that you debugged this down to the internal sql code.


Karen Gayda
MCP, MCSD, MCDBA

gaydaware.com
Post #356330
Posted Thursday, April 26, 2007 12:52 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 1:59 AM
Points: 648, Visits: 1,877
Refreshingly well written article....but this 'issue' has been present for a very long time (long before SSIS) in Enterprise Manager.  You can fall victim to its consequences, no matter how you script your database.
Post #361044
Posted Thursday, April 26, 2007 1:42 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 2:35 AM
Points: 568, Visits: 1,606
Hate to think how much coffee and hair pulling it took to weed this out

-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible.
Post #361055
Posted Thursday, April 26, 2007 3:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 5, 2010 1:47 AM
Points: 3, Visits: 10

There are a lot of other erros in this task. Microsoft told us, they will be corrected maybe in SQL2k8. thank you Microsoft!! Very helpful

Post #361070
Posted Thursday, April 26, 2007 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 11, 2010 9:16 AM
Points: 8, Visits: 46

GREAT debugging & documentation!

I've seen this happen before in my databases and did narrow it down to renaming.  I just try not to rename things in Management Studio anymore.  From experience, I found it's more reliable to DROP & CREATE again.

Did you submit this bug to Microsoft?

Post #361140
Posted Thursday, April 26, 2007 7:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 5, 2010 1:47 AM
Points: 3, Visits: 10
Yes, as a premier support customer we opened 2 Calls.  They know the error but they won't change it in the next time.
Post #361142
Posted Thursday, April 26, 2007 9:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 9, 2009 5:26 PM
Points: 1, Visits: 28

I've found that this is not the only task that has execution errors. I recently received SSIS training as well, and from a DBA perspective, everything worked great in class. When I got back to the office, the problems began. Specifically, the copy database task and the transfer login tasks did not do what they were supposed to do. I'll post more information when I get the time to gather the results.

Cheers!

Post #361179
Posted Thursday, April 26, 2007 9:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:08 AM
Points: 226, Visits: 128
A closely related issue exists with the sp_rename stored proc in SQL 2000. If you use sp_rename to rename a view (which Enterprise Manager and Management Studio seem to do under the covers), the view still retains its old name in syscomments. Scripting that view to a file (using Management Studio or Enterprise Manager) and then running the resulting script file will create the view with its OLD name.
Post #361204
Posted Thursday, April 26, 2007 11:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 23, 2014 3:43 PM
Points: 30, Visits: 300

caveat:  Good luck changing a system table in 2005




Post #361268
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse