Khades (2/6/2012)

---

I have a name column coming from my source. I need to get the ID for each name. The table in which the name and ID columns are stored,...

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?

Also, check this KB article:

The SSIS 2008 runtime process crashes when you run the SSIS 2008 package under a low-memory condition

How do you load those files? In parallel or one after another?

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...

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...

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".

There are a lot of options:

* replication

* mirroring

* log shipping

* SSIS

At first glance, I would say replication is your best option.

Could you include some sample data and the desired results?

(read the link in my sig about posting questions)

soniaj (2/6/2012)

---

Koen Verbeeck (2/6/2012)

---

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...

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

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...

quillis131 (2/6/2012)

---

Matt Miller (#4) (2/6/2012)

---

AS400 is a midrange operating system (think mainframe). You're not going to be able to hook up to it directly because it has a very...

Easy one, thanks Steve!

Cadavre (2/6/2012)

---

Tried polite and unpolite impolite comments directed at him, neither received a reply so...