Kit G (5/28/2009)

---

jcrawf02 (5/28/2009)

---

Tom Brown (5/27/2009)

---

As a complete and totally unrelated aside: -

There's a character called Trigger in the BBC comedy...

Reminds me of the Four Candles sketch by the Two Ronnies

http://www.youtube.com/watch?v=qu9MptWyCB8

There is the source control option from within business intelligence studio - but its not part of SQL Server - that would be the obvious choice for tracking.

SSIS Packages...

Roy Ernest (5/28/2009)

---

I know that I am going to be kicked from several sides for this statement.... But here it is..

"There are two animals that I dislike, One is Snake...

Thanks for the advice, but somethings gone seriously kaputt with my 'Microsoft.Jet.OLEDB.4.0' driver - linked server returns the same error as openrowset

I have temporarily got round the problem by...

OK - the other Openrowsets WERE working fine yesterday (I didn't check earlier), however today they don't work at all. Nothing using the Jet driver works now. I've...

Yes most Odd

even without the dynamic part its failing

insert into OPENROWSET(

'Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\Temp\XL_20090528.xls',

'SELECT * FROM [tab1$]')

select * from sys.syslogins

I've verified the sheet name matches, tried renaming with and without the '$'...

Unless ... :w00t:...

No sooner had I read the last couple of echo comments than I recieve a notification

http://www.sqlservercentral.com/Forums/Topic724894-146-1.aspx

He's done it again.

EDIT: and now I'm echoing Roy :hehe:

I have an existing spreadsheet, I'd changed permissions to everyone full control, made sure it was no longer open in excel - and its still failing. I must be...

I tried this - changing your table names to match my system

DECLARE @dt varchar(8)

declare @newfile nvarchar(100)

SELECT @dt = Convert(varchar(8),getdate(),112)

set @newfile='C:\temp\XL_'+@dt+'.xls'

Declare @XLString nvarchar(4000);

SET @XLString='

insert into OPENROWSET(

''Microsoft.Jet.OLEDB.4.0'',

''Excel 8.0;Database=C:\temp\'+@newfile+''',

''SELECT * FROM [tab1$]'')

select *...

OPENROWSET does not accept variables for its arguments.

Check out tables in msdb such as [dbo].[sysdtspackages] - there are a few others with similar names too.

You have a mismatched bracket here

SELECT * FROM OPENROWSET('SQLNCLI','DRIVER={SQL Server);Server={Named Instance};

Should be DRIVER={SQL Server}

If you have TableA, and TableB - do you want to UPDATE existing rows in TableA with data from TableB, or INSERT new Rows from TableB to TableA, or (as...