Try to clear all cells from this worksheet before writing to it. May be it has any older external data source in this area.

Verify that this database is accessed used connection attached to this task. May this database uses another database schema than dbo or is accessed as linked via linked server.

Right click on SSIS Packages and enter MIgrate DTS 2000 Package option.

Please translate it to english.

For SSIS use parameters but the answer is different for different types of connection (OLE DB, ADO, ADO.NET and ODBC).

Look at this:

http://www.sqlis.com/58.aspx

Yes, indexes should be clear after truncation and never be rebuilded during all lifecycle of your DW (till next truncation). So there is no need to reindex indexes in your...

Try to do reindexing as separate task, not as ETL task.

Yes, I think the same. But reindexing...

Are you asking about SSIS 2005 or DTS?

Second question: after truncation all indexes in destination tables are fully operational (during insertion) or are removed?

Please give me one more chance to understand how your SSIS package works.

Your package do the following tasks:

1. Truncate,

2. Transfer data

3. Reindex.

Is your package works this way?

Inserting records is handled by OLE DB Destination, updating is handled by OLE DB Command. So it must be separated by conditional split or any other component which has splitting...

Is it this variable added to ReadWriteVariables list (Script option of Script Task)?

Please read this thread:

http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx

Hans Brouwer (11/22/2007)

---

So I'm building this package in which records in a dataset either need to be updated(existing) or inserted(new). I use a Conditional Split to separate the records, which...