Hi,

I had this same problem when installing. I ended up using a different local admin account (that was not a service account) with permissions during the install, then changing to...

Hi,

I get the error message:

Because of a protocol error, this session will be disconnected. Please try connecting to the remote computer again.

To get this error I followed the following process:

In...

An explanation I always liked was the shopping mall one. The 'logon' gets you entry to the mall as a whole (the server) but each shop inside is still locked....

Hi,

I used the MS solution for 2000 to 2005 in this link http://support.microsoft.com/kb/246133 to migrate logins from 2000 to 2008 and it worked really well.

Give it a try...

Hi,

Even though you require alter permission to truncate a table, the article in the link below has a 'workaround' where you

you can incorporate the TRUNCATE TABLE statement within a...

Ah, good plan! I'll give it a try. 🙂

You are right, it is using default values (doh!), a total misunderstanding on my part, for all I know I'm still not 'getting it'. So...

I leave the variables blank...

😀

Oh no!

Suppose it's rearrange the expression then.*sigh*

Perfect!

Thanks to both of you. 😀

Problem solved.

For future reference, this was solved with the following:

EXEC MASTER..xp_cmdshell 'C:\Progra~1\7-Zip\7z.exe e "D:\Microsoft SQL Server\MSSQL\Backup\archive_data.7z" "-oD:\Microsoft SQL Server\MSSQL\Backup\"';

Good point! That would probably have sorted out the problem. It doesn't help when you are an SSIS noob like me ;-).

Problem solved - had to recreate the entire package with all new connections. that seems to have 'cleared' the problem.

You are 100% correct, there is nothing wrong with it, I had not replaced one name correctly with the new test udf I created using the code you provided. My...

That code you provided is much better! (I really feel like a bit of an idiot now :))

But unfortunately it produces exactly the same error as I had before -...