If you've never worked with SSIS before, I recommend that you search the web for a "getting started" tutorial. That will help you to create a basic package.

John

This is a bit like being given a nail and told you're not allowed to use a hammer. Why can't you use SSIS?

John

Yes.

Actually, it needs to run every Sunday during the month after quarter-end...so only...

MJ, you need to add...

Is it the log file that grows to fill the disk? If so, clear out the entries one day at a time (or whatever interval best suits your disk...

The second one definitely won't work. It's not valid syntax. Try this - it doesn't work:

DECLARE @string varchar(100)

SET @string = '''A'',''B'''

SELECT * FROM sys.objects

WHERE name IN (@string)

I think...

Ah yes - in my great haste I assumed that your query resulted in the comma-separated list. I can't tell whether the issue here is generating the list, or...

SELECT @HCodes = DISTINCT...

That should do it, shouldn't it?

John

Please will you post the value of your variable (in other words, the command you're trying to run)? It may be that there's another way of doing it. ...

Those are horrible. I recommend avoiding that design if at all possible. I've seen it described as EAV (Entity Attribute Value), OTLT (One True Lookup Table) and MUCK...

Exactly what I was going to say. I would also have added that this will also grant SELECT on views in the schema, so be careful if that isn't...

Not sure whether Gail is being unduly modest or trying encourage you to do your own research. Either way, you may want to read this[/url].

John

No. Nor does the differential.

John

Restore your last good full backup and all transaction log backups after it.

John

Is that...