I think the only problem is the sql syntax. I was able to recreate it fine.

insert into table (Scenario)

Select @Scenario as Scenario

INSERT INTO Scenario

SELECT @Scenario as Scenario

If you dont want to switch to using a date counter, does this work?

Set @StartingMon = @StartingMon + CASE

WHEN RIGHT(CONVERT(CHAR(6),@StartingMon),2) =...

is this it?

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

If it completes without error, but nothing happens, perhaps its not finding the remote file. Does it complete instantly? or does it appear to download a file, but then the...

Can you include the join to the other tables in the proc?

Can you use TRY CATCH?

BEGIN TRY

ALTER TABLE tblproducts ADD isDelete bit

END TRY

BEGIN CATCH

END CATCH

Can you run the code directly on the remote server? I seem to remember getting cryptic errors from a linked server caused by syntax errors. Sometimes the data would change,...

From Visual Studio you can 'save a copy' of the package to the SSIS repository on the server. I don't know if this is a good way to do it,...

Null is not unknown. If I have a table of medical providers, the dob is null for a facility. That doesn't mean its unknown.

I chose null means null, because the...

What OS is on the box? If its XP then it has to be XP Pro so that you can run IIS, but I think it should tell you that.

Variation on the above.

DECLARE @T

TABLE (

row_id INTEGER PRIMARY KEY,

...

Can you post an example query?

Did you ever figure this out? I might have recently done something similar, but its been over a month since this post.

I may have misread the subquery join.

Can you find if it is ever possible for the subquery to return multiple rows? even though it doesn't for the example?

Does this return anything?

SELECT T3.Val1

FROMTable3 AS T3

INNERJOIN Table4 AS T4 ON T4.SomeID=T3.SomeID

WHERET3.Val2 = 1

GROUPBY T3.Val1

HAVING COUNT(*) > 1

and does it work if you change your subquery...