Off hand, not really. I'd use the connection manager to name the file with a base name, then use a FileSystem task to complete the actual rename of the...

In your Flat File connection manager for the output file just be sure that the Column names in the first data row is unchecked.

😎

Sorry, it wont as written. You will have to modify the code as I wrote it for SQL Server 2005. You will have turn the CTE into a...

Based on the article Jack referenced, here is some sample code for you to start with:

create table #TempTable (

RefOne int,

RefTwo int,

...

Colin Betteley (10/22/2008)

---

Hi,

I have a table as follows.

RefOne RefTwo Item Purpose

100 ...

Just to be sure I read your original post correctly. Users have a local copy of Access on thier desktop systems and are linking tables in this local Access...

Definitely like Ken's way of doing it. No loops or calculations required.

😎

Yes, it does. You can use it to create a Data Model.

😎

Check out Enterprise Architect. The reason I purchased it...

I use ERStudio here at work, but at home I have Enterprise Architect from Sparx Systems.

😎

You have to upgrade the CAL's as well.

😎

You really should keep this in the same thread: http://www.sqlservercentral.com/Forums/Topic588510-1291-1.aspx

Have you looked at the recent suggestions given there?

😎

Not sure, as you didn't provide the DDL for the tables or any sample data to test with, but does this work?

;with ProductList (

RowNum,

...

For S & G, put an index on woonplaats. If there are 1.5 million rows, but only 13,000 rows with a null value in woonplaats, you might see a...

Jeffrey Williams (10/19/2008)

---

nilmov (10/19/2008)

---

i slightly differ on that...if it is full logged and your disk is getting full, shrink is the option left. Not regularly but when have a...