As this is an SSIS forum, you can also use the File System Task.

😎

You are missing a comma (,) after todate. Here is the corrected code:

SELECT id, todate,

STUFF((SELECT ' ' + comment

FROM TEST2 a

WHERE...

I see you creating the @tableHTMLapplication at the top of the procedure, then importing the data, then I see to executions of the sp_send_dbmail procedure.

You are creating the body of...

I subscribe to SQL Server Magazine, and it is well worth the investment.

😎

Jeff, Only problem with that, what if they don't have the budget for Enterprise Edition? That puppy can get expensive at street prices, and most discounts that private industry...

Plus the cost of the Developer Edition is well worth the investment ($49 per developer).

As Matt also indicated, if you will not be deploying to Enterprise Edition, be sure to...

If its a staging table that is emptied and reloaded everytime, then I'm sorry but truncate would be faster.

What you may want to do is setup a seperate stage environment...

Jeff, the real killer in that process at my previous employer wasn't the cursor, but the data. About half of the processing time was a result of about 20...

When you say the lookup transformation failed, how did it fail? How were you trying to use it?

😎

I agree with Jeff. That's what I started doing at my last employer when I was trying to learn more about Analysis Services and OLAP cubes. I created...

Now for your other 2 questions.

Max number of columns: 1,024

Max number of rows: probably restricted by the amount of disk space available.

😎

I'll answer your third question right now. Don't use text, ntext, or image data types in SQL Server 2005. If converting a SQL Server 2000 data base to...

There is a side note to the cursor solution, each pass (a single record from the restrictions table) is applied to the inventory records in a set based fashion. ...

Well, unfortunately, I do know of a case where a cursor is the best option (at least at the time). Last employer we had a restrictions table for documents...

I have to agree with Jack. Use the correct data type for the correct data element. I agree, unless you really need to record the time of birth,...