July 18, 2002 at 3:30 pm
I am struggling with passing my code to our admin to check into production. I am looking for any ideas that you use to help communicate what needs to happen when passing code to be checked into production.
Steve Johnson
Steve Johnson
July 18, 2002 at 5:53 pm
Not sure, you should have it scripted and he should make a script backup of anything it replaces. You should announce a downtime that occurrs after a full back preferred and test before you allow other user access. Test your changes live without allowing modification of data if possible. Once you are sure the expected results occurr in production then allow user access. Make sure users let you know of any issues they may have. Beyond that code changes are usually simple and don't take a lot to do.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 18, 2002 at 5:59 pm
Part 4 links to the others:
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
July 23, 2002 at 11:11 am
Steve, you mentioned in your document that you packaged DTS's..... How???? :o)
Steve Johnson
Steve Johnson
July 23, 2002 at 4:38 pm
Save as a .dts file (use the "save as"). Then you can script this as a dtsrun item to run.
Steve Jones
July 23, 2002 at 4:42 pm
Thanks.... I was trying to make it more difficult.....:o)
Steve Johnson
Steve Johnson
July 25, 2002 at 2:18 pm
Is it possible to save a DTS to the server using a script??
Steve Johnson
Steve Johnson
July 25, 2002 at 4:17 pm
You'd have to use scripting and ActiveX to create a reference to the package, then do a save. Not sure how you'd do this from a .dts file.
Steve Jones
July 25, 2002 at 5:25 pm
Pretty easily done. Try this:
Dim oPackage As DTS.Package
Set oPackage = New DTS.Package
oPackage.LoadFromStorageFile "C:\testpackage.dts", ""
oPackage.SaveToSQLServer "eg\one", , , DTSSQLStgFlag_UseTrustedConnection
Set oPackage = Nothing
Andy
July 26, 2002 at 6:36 am
Thanks Guy's you have been a big help
Steve Johnson
Steve Johnson
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply