Updates can be more efficent if done in a t-sql script command and with the correct indexes it can run quickly, can you post some more details about...

If this is urgent then you may getter a quicker response if you post your create table statement, and some sample data in the form of Insert statements..

The best way really depends on your setup and how up-to-date you need the reporting database to be,

If you require up-to-date data then you could use transactional replication to send...

I would go for database mirroring, it is easy to setup and will provide a fail-over partner in the event that the primary database becomes unavaiable.

Also it has the...

You can use the For Each Loop container to loop through the directory.

Put the data flow that reads the file into the container, on the container properties select the...

There might be a Table or Procedure with that name already in the database

Do you have write permission on your c:\ drive? are you able to create files manualy?

No you cant use it in the same data flow task, Sorry now that i think a bit more about it I do not think it will be possible with...

There is a row count data flow transformation that can count the number of rows passed through it and then store this count as a variable for later processing..

Yes thanks for that information,

after doing a test on 10million rows , ISNULL seems a lot quicker. I had been used to using COALESCE since it is the...

Apex has a log reader that works for SQL2K5, I havent used it but it looks like it would work.

http://www.apexsql.com/sql_tools_log.asp?gclid=CNfQ0tn_pZ0CFWAB4wodAEaI1g

Matt Whitfield (10/5/2009)

---

Use ISNULL. I think people use COALESCE way too much when it's not appropriate, and ISNULL is certainly faster.

Edit -> in fact, wtf am I talking about, use...

You can use an UPDATE statement with a Join.

UPDATE A SET myCol=B.myCol

FROM myTable A

INNER JOIN myOtherTable B ON A.ID=B.ID

Post your two table defintions for more specific code

Use COALESCE

DECLARE @aa VARCHAR(1000)

SELECT @aa = COALESCE(@aa,'') + EmpId+ ' ,'

FROM YourTable

SELECT @aa AS EmpIds

The transfer task is created by the wizard and is a complex task that cannot be edited in manually by SSIS, so looking the advanced editor will not work.

You need...