Viewing 15 posts - 496 through 510 (of 2,636 total)
matias.diaz (2/20/2009)
-----------------------------------------------------------
OPEN Lista
FETCH NEXT FROM Lista
Into @Type ,@Name , @Owner
WHILE @@FETCH_STATUS = 0
BEGIN
if (@Type ='P' or @Type ='F')
begin
exec('grant all privileges'...
February 20, 2009 at 9:20 am
Make sure you run Upgrade Advisor for the SQL 2000 database first to see if there are any issues that you can take care of before migrating. This is...
February 19, 2009 at 3:21 pm
I don't know the cause, but have you run SQL Server Upgrade Advisor on the SQL 2000 databases to see if there are any upgrade issues?
February 19, 2009 at 2:59 pm
Please don't post the same question in multiple forums. The question was answered here: http://www.sqlservercentral.com/Forums/Topic660012-8-1.aspx#bm660518
February 19, 2009 at 9:38 am
If your packages are stored in SQL Server, you can also view the log info by right-clicking on the package in the "Local Packages" list in Enterprise Manager and selecting...
February 19, 2009 at 9:33 am
Do you want to move the database to another SQL 2008 instance? If so, make a full backup and restore it on the destination instance. If the destination...
February 19, 2009 at 9:27 am
Thanks, Chris. I hadn't used dtutil, but I'll check it out now.
digitalox, read the discussion thread for this article. There's a post that describes how to do what...
February 19, 2009 at 9:16 am
You either have to open each package in Enterprise Manager and save it to a file or use DTSBackup2000, a free download available from SQLDTS.com http://www.sqldts.com/242.aspx. The advantage of...
February 18, 2009 at 4:42 pm
kotlas7 (2/18/2009)
February 18, 2009 at 3:48 pm
Have you looked at putting the connections in configuration files? I would think you'd be able to easily modify the config files without having to edit each package.
February 18, 2009 at 3:38 pm
If the packages are saved with an owner password set, anyone who knows the password can edit, save, and run the package. See "Handling Package Security in DTS" in...
February 18, 2009 at 1:08 pm
No, because the entire package is stored as binary data in sysdtspackages90.
February 18, 2009 at 12:50 pm
If you connect to Integration Services in SSMS on the server where the packages are stored, you can right-click on a package and select "Export Package..." which will let you...
February 17, 2009 at 10:08 am
I've seen this error when accessing a file that is not on the server where the DTS package is running. If that's the case here, try using a UNC...
February 13, 2009 at 11:06 am
I'm pretty sure that date is not stored in any system table. Sorry
February 13, 2009 at 11:01 am
Viewing 15 posts - 496 through 510 (of 2,636 total)