Viewing 15 posts - 1,291 through 1,305 (of 4,272 total)
I think a lot of people are missing a fundamental point, under other regulations much of this data should have already been protected. I worked in a big bank...
June 22, 2011 at 10:13 am
The FEL container is operating correctly. I think there is a solution, it is predicated on the files being moved or renamed so they don't satisfy the FEL search...
June 22, 2011 at 9:55 am
I believe approach 1 is the best answer and I don't think there will be any performance hits. It will still open 4 connections anyway.
CEWII
June 22, 2011 at 9:26 am
By default it will run up to 10(I think) processes in parallel. What you are experiencing is very likely SSIS "throttling", it can't run all 5 well at the...
June 22, 2011 at 9:23 am
How many records are you typically going to be inserting? If its a lot I wouldn't do this in an EXEC SQL task but a Data-Flow task.
CEWII
June 21, 2011 at 1:54 pm
And you need all the data in all the tables?
CEWII
June 20, 2011 at 3:57 pm
So maintaining local copies that are refreshed daily is an acceptable remedy? great.
I'd use SSIS to do a truncate and bulk load of the tables of data. how...
June 20, 2011 at 3:43 pm
I'm guessing it might be a permissions issue, such as SQL is not running as a use that has enough rights to see all the drives, but I'm not sure.
Also,...
June 20, 2011 at 3:11 pm
you are very welcome.
CEWII
June 20, 2011 at 2:33 pm
In short no, the solutions and the packages are not inter-related in the DB at all. You could do a search in source control for the package name, which...
June 20, 2011 at 2:18 pm
I don't think it will require a SQL restart, a MSDTC restart for sure.
For machines that will not be on the receiving end of DTC calls I generally do not...
June 20, 2011 at 2:14 pm
I'm guessing you are connected to the SSIS server.. Connect to SQL, expand Management, Expand Maintenance Plans, and if you right click on the plan it will have a...
June 20, 2011 at 1:53 pm
You should be able to edit the package right withon SSMS. why do you think you need to export it to edit it?
CEWII
June 20, 2011 at 1:36 pm
First, I think you should start a new Post, this one is 8 months old.. In that post you should say what you tried and explicitly say what your...
June 20, 2011 at 1:11 pm
You could use the import/export wizard to have it do most of the work, right there near the end it gives you the option to save the package. You...
June 20, 2011 at 1:06 pm
Viewing 15 posts - 1,291 through 1,305 (of 4,272 total)