So in your data flow you remove the commas and then you do the conversion, and you're still getting errors?  You'll probably need to set up a data watcher to...

Yes, that's what I'm suggesting.  But you haven't confirmed whether you're doing the conversion as part of the data flow, or after the data flow has moved the data into...

So do you have a data conversion operator as part of your data flow, or do you import directly to a table with a varchar(500) column and do the conversion...

I'm not sure what you mean by "from inside the CMS", but does this help?

John

As RVSC48 says, use Add/Remove Programs.  You can choose which components and/or...

Sam

You hint at the answer in the title of your thread.  Since you're inserting a column of values in one go, those values all have to have the...

I'm not saying that they necessarily looked at the execution plans at all - just that that may be a reason why they insisted on access to the server.

It depends.  I suppose they may have looked at tempdb or at the execution plans.  However, they ought to specify why they need access to the whole server.

John

Nader

Difficult when I can't see what's in your database.  But try changing referencing_id to referenced_id in the join predicate of the anchor part.  I recommend that you arrange...

Nader

Yes, that's right.  The view sys.sql_expression_dependencies contains one row for each column dependency, so if, for example, ViewA explicitly selects three columns from TableA, there'll be three rows. ...

Nader

The reason you aren't getting any results from the recursive section of your CTE is the AND referencing_id IS NULL clause.  referencing_id is not a nullable...

You've still used name in the second part of the CTE, which is where I said you need to change it.

John

Here's a quick and dirty method.  Provided you know in advance the names of the servers and logins and the new passwords, you could use Excel to generate a script...

You'll probably want to run a trace or Extended Events session to see who or what is connecting as this user.  There may be several reports set up to use...