Red Gate's SQL prompt will show code when you hover over an object.

If you have exec MyStoredProc you can hover over the proc name, right click and see the code....

In the conditional split you could compare the birth date to today's date minus 20 years.

BirthDate > DATEADD("yy",-20,@[System::StartTime])

Just be sure to watch your boundary conditions. @[System::StartTime] is date/time and I'm...

Depending on how big your table is it might be easier to delete a bunch of rows, process your cube, then add them back.

Just make a copy of the data...

So you want to add more rows to an existing table, not just create a new table and load it?

If that is the case post the DDL for the table...

You just need 400K rows? You could build a tally table.

Basically just cross join a system table to generate as many rows as you need.

http://www.sqlservercentral.com/articles/T-SQL/62867/

The deployment order won't matter. As long as both packages are on the server and the config that you are using has the correct information for its environment you will...

Package configurations are what you need. They allow you to manage package properties externally.

http://msdn.microsoft.com/en-us/library/ms141682.aspx

The way I’ve used configurations to deploy from dev/uat/prod are:

Create an environmental variable on each server that...

First you need to identify the business key, the column or columns that make the data unique in your source system. You say pDate and PType are identifiers but they...

You might try a partially cached lookup to the big table.

Set up a data source to Server A to get the 20,000 rows. Run the output into a lookup task...

Can you post the DDL for your table along with any constraints, and reformat your data like it says in this post?

http://www.sqlservercentral.com/articles/Best+Practices/61537/

The Kimball group has some templates.

http://www.kimballgroup.com/html/booksMDWTtools.html

See the download under "Chapter 2 — Designing the Business Process Dimensional Model" / "Dimensional modeling spreadsheet"

This spreadsheet has macros to generate DDL scripts, which...

There are two tools I know of, both plugins for SSMS.

SQL Refactor from Apex SQL

http://www.apexsql.com/sql_tools_refactor.aspx

SQL Prompt (professional version) from Red Gate

http://www.red-gate.com/products/sql-development/sql-prompt/

What are you ultimately trying to do? If you are looking to find dependencies that can be difficult.

sys.sql_modules is a SQL 2005/2008 update from the 2000 syscomments table. It...

You can also use INFORMATION_SCHEMA.COLUMNS.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'GetProgramsPrivileges'

If there are certain results you like from sp_help you can take the code from that stored procedure and make...

SQL Sentry has an Event Manager tool that schedules SQL Agent jobs, among other things. You can set up job execution chains that have various dependencies.

http://www.sqlsentry.net/event-manager/sql-server-job-scheduler-enterprise.asp