This is kind of grasping at straws but is there any chance you are using a package configuration, or a variable for the name of the file? Basically anything...

How do you have "filename".csv listed in your connection manager? Don't forget that when you run it as yourself all of your mappings are there and the package is...

If you arn't using your default instance anymore I would definatly stop it. Although be warned that SSIS is instance un-aware and anything that you store on the "server"...

Is your new named instance running on the same box as your old default instance? And is your old default instance still running?

We created a named instance...

Actually I'll bet you have your default collation set to be case sensative. On all of the systems I have run it on the server has been case in-sesative...

Thats probably when the database was created.

Kenneth

They are system views. They do only exist in Master but everyone should have access to them and they can be used from any database. Just like the...

Here is an article on writing to a file using the filesystem object and sp_oacreate

http://www.sqlservercentral.com/articles/Miscellaneous/writingtoafileusingthesp_oacreatestoredprocedurean/1694/

I've used the filesystem object like this to read from a file as well but can't...

And just to make things more interesting no you should not ALWAYS have a clustered index on a table.

If a table does not have a clustered index it is considered...

GSquared (2/8/2008)

---

Joe Celko (2/7/2008)

---

No, of course not! Think about it for a minute. Tables are all different; they model one and only one kind of entity. So...

Insert the output of a SP into a table like this:

INSERT INTO TableName (FieldList)

EXEC StoredProcedure

I didn't realize there was anything special you needed to do with SSRS to access a...

Here is a nicely laid out view that makes looking at the foreign keys a lot easier (IMHO).

You can pull all keys that touch a table as either a parent...

SQLPermissions is freeware made by Idera.

You can use it to script the permissions for all users on a database, one user on all databases, all users on all databases.

Its by...

Personally I use a tool called SQLPermissions. I'm not sure you can do what you are looking for through management studio. At least I havn't found a way...

toniupstny (2/8/2008)

---

Nice script.

A couple of questions for you:

- Shouldn't there be a set of [ ] around the variables in case they contain special characters...