Viewing 15 posts - 8,101 through 8,115 (of 11,678 total)
Khades (2/6/2012)
February 7, 2012 at 12:38 am
Does the task fail immediately or after some time?
Maybe you got a time-out or something?
Do you have any parameter mapping or resultset configured?
February 7, 2012 at 12:36 am
Also, check this KB article:
February 7, 2012 at 12:31 am
How do you load those files? In parallel or one after another?
February 7, 2012 at 12:28 am
You are right, for some reason you can't select that provider in an OLE DB connection manager. (although the provider is installed on the server. Damn you SSIS!)
Try the following:
create...
February 7, 2012 at 12:27 am
What is the recovery model of your database?
With such a huge query involving so much data, there will be quite some logging overhead. So minimize the logging by switching to...
February 7, 2012 at 12:21 am
So you adjusted TypeGuessRows in the registry to 0?
In the Advanced Editor for the Excel source, check the datatype for the output column "comment".
February 7, 2012 at 12:19 am
There are a lot of options:
* replication
* mirroring
* log shipping
* SSIS
At first glance, I would say replication is your best option.
February 6, 2012 at 11:57 pm
Could you include some sample data and the desired results?
(read the link in my sig about posting questions)
February 6, 2012 at 11:55 pm
soniaj (2/6/2012)
Koen Verbeeck (2/6/2012)
February 6, 2012 at 11:53 pm
More resources:
Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005
Recovering SQL Server Built-in Administrator Access to Database
February 6, 2012 at 11:32 pm
Members of the built-in Adminstrators group in Windows are not automatically members of the sysadmin role since SQL Server 2008. Only the one that installed SQL Server is granted sysadmin...
February 6, 2012 at 11:29 pm
quillis131 (2/6/2012)
Matt Miller (#4) (2/6/2012)
February 6, 2012 at 11:24 pm
Cadavre (2/6/2012)
Grant Fritchey (2/6/2012)
Go easy on him. He's trying. Gentle guidance, not all up in his grill.
Tried polite and unpolite impolite comments directed at him, neither received a reply so...
February 6, 2012 at 12:55 pm
Viewing 15 posts - 8,101 through 8,115 (of 11,678 total)