You can use a dirived column and substring. What defines garbage? How will you recognise a compute name in the string?

is you run the package on the server through BIDS using the same user as Agent is running as?

Sounds like a security type issue. What does Compact DB task do?...

Not sure what the limitations are for Jet but obviously it's not working.

Why not use a derived column and have the case statement in there?

Open the component, click on imputs and outputs. Highlight the Output0. In the properties panel, change the SynchronousInputID to None.

This will detach your component's input and outputs. You will have...

According to BOL, your stripes should be 64k. (Same size as an extent)

If you are wanting to duplicate rows to your flow, add a script component, in the ouput properties, change it to async. In the script, you can process and pass...

"Microsoft haven't quite got their heads around search tools yet"

I disagree. I disagree with the word "quite". They just plain have not. Granted, an intelligent search engine must be difficult...

You can use a left outer join to do the same.

Show me everything in table 1 where not in table 2.

So long as your columns are correctly indexed, it'll be...

The point is always accuracy. No real reason behind a database if you answers are not accurate. Extra cycles used for the query are relative. If your query is taking 4...

It becomes a non SARGable query then. Doing a left outer and left.column is null would be better. As already stated.

http://www.sql-server-performance.com/tips/t_sql_where_p2.aspx

It's the same as a SQL task. You specify the query and place ? where you want parameters.

You then map them to a variable by clicking on the Parameters button....

Is it SQL throwing the error or IIS? What's the event log say?

2-3GB of memory used is not really that much. if you are using a 32 bit server, then...

You are correct,

SSIS loads the config file and tries to set the value of properties specified in the file.

If a property path is not found, it cannot set it. The...

You cannot apply log back ups from 2k5 to 2k. Even if compatability is set to 2000.

I kept the 2000 backup and all the log backups. after testing 2005 was...

You cannot truncate a database. What are you trying to accomplish?

You can drop all tables or truncate all tables but not truncate database.