Tag Info

Hot answers tagged

3

Since you mentioned you want to copy table data only I guess SSIS would be perfect. I have been using it and it works just fine for me. It also depends on level of competency you hold with SSIS. You can go for backup restore but it would also restore tables whoes data you dont want to change. If you want complete refresh then of course no better option than ...


3

Yes, DTutil is still going to be the best option. I have a post, SSIS Package Extract from MSDB on how to use dtutil + the data in the packages table to generate the call(s) to export to disk. Instead of the file destination, you would substitute sourceserver. If you've used folders to organize your packages, then you'll need to create them beforehand. ...


2

How many is "several"? If it's three or four, I'd start by writing a simple .NET script in SSIS which sorts out the files into separate directories. Use several foreach loops, each working in its own directory, with the files in that directory having a consistent format. If there are a lot of formats, it'd probably be faster to write a little application ...


1

First, make sure you have a user in msdb associated with their login. USE msdb; GO CREATE USER username FROM LOGIN loginname; Next, deny execute on sp_help_job and sp_start_job for that user. USE msdb; GO DENY EXECUTE ON dbo.sp_help_job TO [username]; DENY EXECUTE ON dbo.sp_start_job TO [username]; Next, create two wrapper stored procedures that ...



Only top voted, non community-wiki answers of a minimum length are eligible