Viewing 15 posts - 61 through 75 (of 2,635 total)
That works, as you've seen. The .dtsx file contains the changes you've saved. It's also a good idea to save the package\solution in source control also.
June 7, 2011 at 11:00 am
We use ApexSQL Log and like it fine. I works with either live t-logs or backups.
May 26, 2011 at 5:09 pm
Elliott Whitlow (5/25/2011)
You might have to work a little "magic" to elevate the rights.
I've done this by creating a SQL Agent proxy for SSIS package execution and using EXECUTE AS...
May 25, 2011 at 12:30 pm
Hmm, you can have the step in JOBB retry several times before failing. Maybe set retry attempts to 3 with a retry interval of 30 minutes?
You set retry attempts...
May 19, 2011 at 10:55 am
SP_CHANGE_USERS_LOGIN still works in SQL 2008, but it won't in future versions. BOL recommends using ALTER USER instead.
May 19, 2011 at 10:44 am
How would I make the job on Server A a predecessor to the job on Server B? Would there be a way to somehow have the JOBA update...
May 18, 2011 at 10:32 am
I and my coworkers are combo development/production DBAs and probably 50 - 60 percent of our time is self-directed. We, of course, have production timelines that we work within, but...
May 13, 2011 at 9:24 am
DTS package passwords protect the package, not any data that the package may process.
April 29, 2011 at 8:54 am
Put the package execution in a SQL Agent job step. When you create the new step choose 'SQL Server Integration Services Package' as the type.
April 28, 2011 at 9:29 am
If it's okay for webUser to select from any user table in the database, you can make him a member of db_datareader fixed database role. Can you check the...
March 30, 2011 at 9:56 am
GBimberg (3/23/2011)
Some SSIS packages were upgraded to visual studio 2008, without making backups.
When I run them in visual studio, everything is fine. When a SQL Server Agent runs them,...
March 25, 2011 at 9:37 am
Pragmaticworks has a product called DTS xChange for converting DTS to SSIS. I've demoed it and it worked fine.
I don't know offhand about any 3rd party replication...
March 23, 2011 at 10:49 am
Dan.Humphries (3/21/2011)
March 21, 2011 at 9:47 am
To decrypt a DTSRUN command as used in a job step, copy the command to a cmd prompt, append /!X /!C to the end, and run it.
The !X argument blocks...
March 17, 2011 at 9:01 am
Basically, you would restore a backup to a new database and copy the table and data back into the original database.
How you do the restore depends on the database's recovery...
March 9, 2011 at 12:12 pm
Viewing 15 posts - 61 through 75 (of 2,635 total)