Are you able to modify the table structure at all?

As the warning message suggests, if you have more than 8060 bytes in an INSERT or UPDATE operation it WILL fail....

As I mentioned above the main difference is if you use the Multi Phse datapump in data transformations. This switches the datapump into row-by-row processing instead of a bulk load.

If...

In that case the fields MSR_Incent.Teller, MSR_Incent.Branch, MSR_Incent.Acct, MSR_Incent.Sfx, MSR_Incent.DOS &  MSR_Incent.Base_Serv do not make up a unique key.

You'll need to specify all necessary fields that make up the...

For the log files information, check the topic "Reporting Services Trace Logs" in the Reporting Services Books Online. There is also a link on that page for the configuration file...

Try using a LEFT JOIN instead.

blah...
blah...
 Msr_Incent_I.Has5Da
  FROM Msr_Incent_I
  LEFT JOIN Msr_Incent
       ON MSR_Incent_I.Teller = MSR_Incent.Teller 
       AND MSR_Incent_I.Branch = MSR_Incent.Branch 
       AND MSR_Incent_I.Acct = MSR_Incent.Acct 
       AND MSR_Incent_I.Sfx = MSR_Incent.Sfx 
       AND MSR_Incent_I.DOS = MSR_Incent.DOS 
       AND MSR_Incent_I.Base_Serv = MSR_Incent.Base_Serv 
WHERE...

There is no "simple" way

One option is to write a VBScript to programatically open the package change the properties and save the package...

Take a look at the Custom FTP task available at http://www.sqldts.com

Nice article, but would have liked a mention that using the Multi-phase Datapump to transform data will switch the datapump to row-by-row processing. This is something that people should be...

Maybe a bit more information about what you're trying to achieve would allow a more informative answer

Do the log files located at, "C:\Program Files\Microsfot SQL Server\MSSQL\Reporting Services\LogFiles" give you any clues? You should be able to see when your subscription runs. The following is the sequence...

How about adding a column to the input table that signifies that that data belongs to User1 or User2. Then have your stored procedure work on the data for the...

For the ActiveXScript task you'll need to supply the correct parameters for the Load method.

object.LoadFromSQLServer ServerName, [ServerUserName], [ServerPassword], _

    [Flags], [PackagePassword], [PackageGuid], [PackageVersionGuid], _

    [PackageName], [pVarPersistStgOfHost]

The "Flags" parameter takes one of two...

Greg

Where do you hail from?

You might have noticed the links in my signature, that's a start if you're an Aussie

Otherwise checkout MSDN Connections, they...

The sp_OA... procs are kinda handy, but it gets a bit hairy when you're passing in more than a couple of global variables for your package.

That's one of the reasons...

This seems to be one of those irritating intermittent bugs that has no definite reproducible steps. I have a couple of Packages that...