It would help immensely if you were to provide the DDL for the destination table, and a representative sample of the data that would reside in that table using the...

SQL Server is unaware of the image format. You could store a Word doc or a PDF in a VARBINARY(MAX) column for all it cares. The bits are stored in...

:exclamation: Note: this is a year-old thread.

Koen Verbeeck (5/24/2012)

---

opc.three (5/24/2012)

---

The two Execute SQL Tasks you mention point to the same database, using the same connection, sounds good. What happens to that transaction if an exception occurs...

I'll second, third, and fourth that...education, education, education!

If that is a lost cause, I know it was in some shops where I have been, you might look into enabling...

It is a function, not a global variable. Try it like this:

return SCOPE_IDENTITY()

A no-cursor option:

DECLARE @sql NVARCHAR(MAX);

SET @sql = N'';

SELECT @sql = @sql + 'EXEC msdb.dbo.sp_send_dbmail

@recipients = ''' + REPLACE(email,'''','''''') + ''',

@subject...

This may help:

SELECT TOP 10

DB_NAME(x.dbid) AS db,

OBJECT_SCHEMA_NAME(x.objectid, x.dbid) AS schemaname,

...

By all means dig in and learn the internals but there is no sense in re-inventing the wheel. May I recommend a solution...

Koen Verbeeck (5/24/2012)

---

opc.three (5/23/2012)

---

MisLead (5/23/2012)

---

I have an execute task that truncates the table when the package runs. Downstream I have dataflow tasks that fetches fresh data and populates that data...

What bruce provided is exactly what I described. You can use the Split-Path cmdlet to get the directory names as you move thorugh the collection of data and log files....

Read the Remarks section here: DBCC UPDATEUSAGE

No, compat mode is not a concern for udpateUsage.

I see it uses statistics...

Sure. If you have to pick and choose then skip running checkdb and skip rebuilding all...

None are technically required. All three are a good idea. I would do 3 before 2 and would use sp_updatestats or UPDATE STATISTICS WITH COLUMNS on all tables.