Well, it has a Delete File operation. And you can dynamically define the connection, so you should be able to delete any file pattern you choose.

John

Why are you doing all those conversions on the date column? Can you not just leave them as datetime? I'd guess that's what's killing performance. In order...

How do you know that the individual column used 100GB?

It could be that deleting the column freed a certain amount of space on each data page, but that the table...

I don't think that's possible with the Maintenance Cleanup Task, since it's done on extension only. Have you tried the File System task?

John

If you have a unique constraint on a column, it doesn't matter what you do with triggers, WHERE clauses and so on - you can still only have one NULL....

George

Another way round it might be to open the file in Excel, format the columns appropriately and then save it and import from that. You could write a VB...

Jeff

Yes, I did think about asking why he posted in this forum, but it such things seem to happen so much these days that I don't usually bother!

John

George

I think the problem is that 1,400.00 is actually a number, which is being sent as text because it has a "," as a thousands separator. I would import...

Something like this. The INSERT statement will only work in 2008.

CREATE TABLE #Docs (DocNo int, Line char(1), LStatus varchar(2))

INSERT INTO #Docs VALUES

(1, 'A', 'QA'),

(1, 'B', 'QV'),

(1, 'C', 'O'),

(1,...

Yes, that's the old-style join syntax which is deprecated for inner joins, and obsolete for outer joins. Goes something like this

SELECT * FROM Table1 t1 JOIN Table2 t2

ON t1.ID...

For the first one, look in Job Activity Monitor. For the second, you'll need to write a query against sysjobhistory (like I think you would also in SQL Server...

I don't think you can. But read the ALTER Login topic in Books Online - you may or may not be able to find a way round it by...

From Books Online:

CHECK_POLICY = { ON | OFF }

Applies only to SQL Server logins. Specifies that the Windows password policies of the computer on which SQL Server is running...

Flodpanter (11/26/2010)

---

This Insert will create 100 new records all with unique identity values in the table dbo.table_referencing_project. Now I have to copy all data that references the dbo.table_referencing_project table. These...

It sounds as if there's something in Visual Studio 2008 or Integration Services 2008 that is insisting on a SQL Server 2008 database. What is the task that is...