Viewing 3 posts - 1 through 3 (of 3 total)
Greg Charles (11/25/2008)
Amit Joneja (11/25/2008)
After importing the DTS packages, I right-click and choose "Migrate Package".
Ah, omitting that bit in your original post is what threw me off. BTW,...
November 25, 2008 at 1:57 pm
After importing the DTS packages, I right-click and choose "Migrate Package". That saves the package under Integration Services -> MSDB.
When I create the job, if I choose Type as "SSIS...
November 25, 2008 at 12:00 pm
OK, so if I was to run these queries in sequence:
1. ALTER TABLE mytable ALTER COLUMN field1 varchar (20) NOT NULL
2. UPDATE mytable set field1=rtrim(field1)
and then do a shrink database...
March 10, 2006 at 9:56 am
Viewing 3 posts - 1 through 3 (of 3 total)