Your right :w00t:

For some reason it looked stripped to me before, but now that you have clarified it makes sense.

You can defintely use the value method to retreive the xml...

You can also post your xml document as a text attachement.

Your xml did not post right. Before posting change all your less than and greater than to the appropriate HTML.

e.g.

& lt; and & gt;

They are the same thing, but I would use the alter index rebuild. This allows for online rebuilds and takes less steps.

Rebuilding does drop and create indexes. Rebuilding indexes can be a performance hog, make sure to rebuild indexes at a time where you low traffic or a maintenance window...

DBCC REINDEX is going to be removed from future versions of SQL server. You should use the alter index statement.

more info.

http://msdn2.microsoft.com/en-us/library/ms188388.aspx

🙂

You can use the following logic to get the same result.

declare @dt datetime

set @dt = DateAdd(month, DateDiff(month, 0, GETDATE()), 0)

select datediff(week, @dt, getdate()) + 1

You cannot use cast and the proposed logic. The reason you need Convert is beacause it gives you the ability to format the date, while cast does not. ...

You can also prevent objects from being dropped with DDL triggers. This works espeically well in production environments. You can log all the information about who tried to...

The tempdb is created every time you start the database egine. You need to make sure you dont have any outstanding transactions. Check your error logs and the...

Jack has hit the nail on the head. Confirm that the SQL service account has the appropriate...

NP, glad I could help. 😀

You can evaluate your connection string in the expression editor. Just click the evaluate button and make sure it is pointing where you want it to.

So I can create the destination but when I run the package it tells me the destination does not exist? Normally I don't have to have the file created prior?...