Thanks Carley. Apparantly I was thinking too much in Windows "user groups". Unfortunately this behaviour of SQL Server is not very user friendly because you have to "know" where your...

Jeff, probably I was not clear about the purpose of this. The db user is used only within some SSIS packages for automated data loading and (unfortunately) creation of several...

This is a great idea, thanks!

Rainer

The user creates new views within the dbo schema, so I cannot give him control permissions on object level because these views do not exist yet.

Regards,

Rainer

Sugesh, the user has (as expected) no (explicit) permissions on the views; he can "select" data from the view nonetheless due to his database level select privilege.

As a select privilege...

Check out the DataType settings in the advanced editor. I had several occasions where the data type of the external columns and the output columns did not match. After setting...

James,

I ran into this several times and never was happy with the possibilities DTS offers by default. The only way I could work around this was to use Excel (or...

Not sure what you mean.

The code looks like

Dim fso, f1

Set fso = CreateObject("Scripting.FileSystemObject")

Set f1 = fso.GetFile("c:\test.txt")

Determining if the file is empty might work by checking the size (f1.size =...

If you don't have or want MAPI installed on the server and you also don't want to use an additional tool you might use cdo. The following - which I...

You could implement a logic similiar to the looping logic for DTS using the DTSStepExecStatus constants and some script code that checks if the text file is not empty and...

This also strongly depends on the OS. We had a similiar setup with Windows 2000 and 4 hyperthreaded CPUs and once in a while experienced _massive_ performance problems (as it...