Viewing 15 posts - 38,506 through 38,520 (of 39,456 total)
I don't think the dynamic task will do this. If you want to work with files, you need the file system object. See my Push FTP article for an example....
December 28, 2001 at 4:23 pm
It willl help if you can post the table and explain exactly where each piece of data is.
You probably want a task rather than a trigger, but until you define...
December 28, 2001 at 4:22 pm
December 28, 2001 at 11:14 am
You can look at my article on PushFTP. This could be easily altered to do renames instead, however, you need to know the file names. If you do not know...
December 28, 2001 at 11:10 am
You can also make the change in em, then click the script button. It will allow you to save a script of your changes and you can examine this.
Steve Jones
December 28, 2001 at 10:06 am
December 28, 2001 at 10:05 am
At technet, you can also subscribe for the newsletter. It's good to also know about NT/2k patches.
Steve Jones
December 28, 2001 at 10:03 am
I used Visio currently. It works ok for the initial reverse engineering, but maintaining it is a manual process and it has flipped out with my groups, so I now...
December 28, 2001 at 10:02 am
Keep in mind, you never want to "delete" the log file. It is essential for operation of the db. It can go out of control. Check out Andy's and Brian's...
December 28, 2001 at 9:53 am
Ahhh, sorry.
Add the task to your package. Then "set" a new value and you can basically pick any property of the package, including properties of any task already there. Select...
December 26, 2001 at 3:06 pm
np, happy to help.
In enterprise Manager, select the Security item, then the logins. Right click or use the Action menu to add someone. You can then accept a NT group...
December 26, 2001 at 3:02 pm
You'd need to specify one service using a domain acct from the other domain. Not sure if you can do this. You might need a trust between domains.
Steve Jones
December 26, 2001 at 2:34 pm
December 26, 2001 at 2:32 pm
December 26, 2001 at 2:31 pm
Mohammed,
you still need to grant rights by adding the NT groups to the SQL Server.
Steve Jones
December 26, 2001 at 2:30 pm
Viewing 15 posts - 38,506 through 38,520 (of 39,456 total)