Viewing 10 posts - 1 through 10 (of 10 total)
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.
February 26, 2009 at 1:19 pm
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...
February 24, 2009 at 12:43 pm
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...
February 24, 2009 at 12:11 pm
You can use the SSIS Import Export Wizard. The following link provides information on using it.
February 19, 2009 at 7:13 am
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...
February 12, 2009 at 12:31 pm
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,...
February 12, 2009 at 10:31 am
Here are some links for using Parent Package Variable configurations:
Note: you need to add a configuration for each variable you want to retrieve from the parent package in the child....
February 4, 2009 at 7:50 am
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...
February 3, 2009 at 8:55 pm
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...
February 3, 2009 at 2:22 pm
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...
February 3, 2009 at 12:35 pm