hey,

thanks for the reply,

yeah excel just seems a horrid pain, ive been reading up on SSIS frameworks and such, and wondering what people do to make sure the...

haha, yep.. starting to see that as the way forward in the next review!

Installing SSDT has installed dtexec 32bit. It says that the client tools will do it as well...

Well another restart has it working again but the second set of env are still not working. (scared to re-start it as it seems to change with every reboot!

On an...

well this is frustrating!

So, i decided to re-create the the dts.config file that enviro var pointed to, in a new location and re-set the var. Re-started the machine. used SET...

hi, sorry for the delay in getting back to you!

so it looks like its actually an environmental variable issue. The agent job fails with the jet engine problem, but...

think ive worked it out. forgot that its a xml column that ive parsed to a value. converting it to a INT then trying again! hopefully it will all come...

Problems solved pretty silly really.

TLDR

Add the proxy account to the ETL Servers "Remote Management Users" group to enable running Posh remotely.

It was failing due to calling powershell remotely without...

Thanks for the replies.

So far im sorted on Versions.

Edition for 2000 im taking from the license.txt file. found in reporting services folder.

Edition for 2005 im lost and still...

Hi sir,

thanks for the reply.

Any ideas on how to get the edition?

For the 2000 box.

I have gone though the registry keys for HKLM-Software-Microsoft-Microsoft SQL Server +...

finally!

sorted it... just been staring it this silly thing for hours now.. clearly lost perspective..

Code that works! thanks again Roland for the help!

DECLARE @server VARCHAR(50)= 'VM-TestServer'

DECLARE...

Thanks Roland,

I found it around the same time to 🙂

Now i have the error

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near '

SELECT SERVERPROPERTY('MachineName'),

SERVERPROPERTY('ServerName'),

SERVERPROPERTY('InstanceName'),...

Thanks for the links much appreciated..

Any suggestions for books? etc. Think i will have to go with the old Amazon review score card at present 🙂

Thank you again...

Hi Nils Gustav Stråbø,

Thanks for the details.. really helpful and copy/pasting them into my notes shortly 🙂

It was originally set up for AD accounts. I got an email...

Hi all thanks for replies..

So a bit more digging. after the suggestions about kerberos and where im connecting. I decided to remote onto the machine (2005 box) When i...

thanks for the link!

Would it still be applicable if i was originally able to query between them?