Viewing 15 posts - 556 through 570 (of 2,635 total)
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.
Greg
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
Greg
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.
Greg
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...
Greg
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...
Greg
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.
Greg
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...
Greg
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...
Greg
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.
Greg
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...
Greg
January 20, 2009 at 9:57 am
Use the Transfer SQL Server Objects task to copy views.
Greg
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. ...
Greg
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.
Greg
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?
http://support.microsoft.com/kb/920298
Greg
January 15, 2009 at 9:22 am
I'm able to edit the packages after moving them to the server select "Package Configurations" from the BIDS menu, and edit the configuration file path.
Greg
January 14, 2009 at 5:25 pm
Viewing 15 posts - 556 through 570 (of 2,635 total)