If you log the files that have been loaded then you have enough information to proceed.

Create a task that checks the table for the file to see if it has...

Books online really describes the securty pretty clearly.

http://msdn.microsoft.com/en-us/library/bb283249(SQL.90).aspx

Can't really give you a clear answer because it really depends on what your trying to do in the long run.

This may be...

Not sure what is in your table valued function but you can do it 2 ways

Select Month, SUM(Month) as MonthlyTotal,(100 * SUM(convert(decimal(4,1), Month))/260504) As Frequency

From GetTotalOf1(@Month)

Group by Month

OR

Select Month, SUM(Month)...

There is no direct way to do this.

If you must physically re-align the identity values rebuild the table as suggested above.

if you just need the values to be incremental on...

Its not the easiest way, to go about it because I don't know the whole problem your trying to solve, but for this specific example you can just return all...

My question is why do you need it in a parameter.

Why not use a recordset?

And if you need it in a parameter there are ways.

From BOL

http://msdn.microsoft.com/en-us/library/ms141124(SQL.90).aspx

After you finish updating the packages, you rebuild the project, copy the deployment folder to the target computer, and then rerun the Package Installation Wizard.

If you update only...

The default .NET Timout value is 30 seconds, if you explicily assign the value you can extend it.

Check this out, and let us know if any of it worked

http://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec

It is not a sp_executesql problem.

Your procedure is only passing back an output parameter of @PersonID,

you can only put 1 value in a parameter.

you need to restructure this call to...

Then you would probably be safe using the UNION ALL Statement, and I think this would eliminate the sort operator.

Do you have precedence constraints on your dimension tables to load and process prior to loading the data into your fact table?

There has to be something where the data is...

hey,

Sure you can do this, but what is your question?

you have to follow the tutorial in the article above, which shows you how to create a tally table.

Sql server does not store dates in the system.

So there is no...

It is my understanding that when a UNION is performed between two SELECT statements, it's internally running a DISTINCT. Is this correct?

Yes Internally sql will only return Unique values.

From...

Look at the column mappings in your Data Transfer Task, are you mapping a source column from the spreadsheet to this column in the table?

If so then the data in...