Viewing 15 posts - 556 through 570 (of 2,636 total)
Brian Knight also has a product that is advertised to migrate all packages in an instance. http://www.pragmaticworks.com/dtsxchange.htm
I haven't tried it, but I've read the specs and may try the free...
January 23, 2009 at 9:10 am
Is "msdb/" part of the package name or are you indicating that it's stored in msdb? If it's the latter, you don't have to specify that.
January 23, 2009 at 8:56 am
If you would rather store the package in the files system, as I do, set the pacakge protectionlevel to "EncryptAllWithPassword".
See this thread: http://www.sqlservercentral.com/Forums/Topic619676-148-1.aspx
January 22, 2009 at 12:43 pm
Open the diagram in SSMS, right-click in open space of the diagram, select "Copy Diagram to Clipboard", open something you can print from e.g. ms Paint or Word and paste.
January 22, 2009 at 11:48 am
My mistake. I should have said, "whichever admin login you want to run the job. When I've created a credential, I've used the login which runs SQL Server...
January 22, 2009 at 11:34 am
It will be whichever non-admin login you want to run the job. If you click on the "Add.." button you'll see your choices are logins, server roles, or msdb...
January 20, 2009 at 1:03 pm
Whether the databases are critical or not, I think restoring backups would be the best way to recover.
January 20, 2009 at 12:48 pm
No. They'll be able to start the job but it will still fail on the package step. You need a proxy that has been configured to use the...
January 20, 2009 at 12:42 pm
The db_dtsadmin role is not applicable to DTS packages. Regardless of whether the job runs a DTS package or an SSIS package, you must create a security credential and...
January 20, 2009 at 10:26 am
Good advice. Since the Transfer Objects Task is no longer available in the Import/Export Wizard, scripting is the easiest way to copy views.
January 20, 2009 at 10:03 am
I'm interested in this subject because we're preparing to move a server into a DMZ also. My understanding is that the server in the DMZ shouldn't be able to...
January 20, 2009 at 9:57 am
Use the Transfer SQL Server Objects task to copy views.
January 15, 2009 at 10:26 am
Check the permission properties of db_dtsadmin and verify that it has execute permission for sp_dts_listfolders. It does in all my SQL instances and I think that's the default. ...
January 15, 2009 at 9:52 am
Mh,
The script will work for copying logins to SQL 2008 because logins are essentially unchanged between 2005 and 2008.
January 15, 2009 at 9:35 am
Although I haven't had a problem editing a standalone package, maybe your problem is the one in this kb article. It might be worth trying the workaround?
January 15, 2009 at 9:22 am
Viewing 15 posts - 556 through 570 (of 2,636 total)