Your connection string is not correct. Check out this site:

http://connectionstrings.com/ to see the correct way to use connection strings. In your example Data Source should just be the...

Could you post some sample data in the format you are loading from, the table schema you loading it into, and the settings of your package?

I have never...

For the group, deny access to the schema tables/views. Public, which everyone is in by default, has rights to these tables.

You should be all set as long as the script does create the needed objects later on.

Is the Windows Firewall enabled on both machines? If so, you will need to create an exception for the debugger.

I want to preface my comment by stating that I know nothing about Analysis Services.

First, when you run the query outside RS or in the DataSource tab are...

Not sure what you mean by:

First make sure the beginning of your sp has SET NOCOUNT ON.

How are you using the...

When running a SQL Server job the job runs using the credentials of the SQL Server Agent service. By default the SQL Server Agent Service installs using the...

I don't have problem with this but he says that these days the DAL should talk directly to the database an all database access control should take place in the...

Thanks, Lynn.

See I told you I posted questions.:P

One of my problems is that I have had to do a little of everything, so I am not really an expert in any 1 area of SQL Server. ...

Does the SQL Server service account have rights to the directory?

is the distributor set to allow remote connections?

Matt Miller (3/3/2008)

---

Jeff Moden (2/29/2008)

---

Folks, when you do an interview, remember... you're not trying to show off how smart YOU are, you're trying to figure out how smart the other...

Remember that ultimately your boss is writing your reviews and any future references you might need. If your boss is not supportive when you do what you were hired for,...