Change 'NewParameterName' in the Parameter field to 0. This assumes you are using an OLE DB connection, which uses numbers to identify parameters, starting with 0.

The length returned by sp_help is "Column length in bytes." (BOL) and nvarchar uses two bytes to store each character. So, the columns are actually nvarchar(100), and should...

Packages stored in SQL can be managed by connecting to the Integration Services instance on the server you saved the package to. From SSMS, click connect, choose Integration Services...

You can use the SSIS Import Export Wizard. The following link provides information on using it.

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

Tim's solution works and is the easiest for this case. Having said that, here is some info on using SSIS variables to do the same thing, which can come...

There is a Notify Operator task available in SQL 2005 maintenance plans (which are really SSIS packages). It allows you to send a message to one or more operators,...

Here are some links for using Parent Package Variable configurations:

http://technet.microsoft.com/en-us/library/ms345179(SQL.90).aspx

http://www.sqlis.com/post/Using-Parent-Package-Variables-in-Package-Configurations.aspx

Note: you need to add a configuration for each variable you want to retrieve from the parent package in the child....

In addition to using a variables table in a SQL database, you can use package configurations to share variable values among multiple packages. This works best if the variables...

Using a left outer join will improve your performance. I added the NOT EXISTS and OUTER JOIN methods to your code.

--Get the count of sparsekey values that are NULL...

Here is another option that may work for you. It starts with using Union to add the default value to a result set, but only reads the primary table...