sql server dts: SQLServer Error: 536, Invalid length parameter passed to the SUBST -- sql server dts

SQLServer Error: 536, Invalid length parameter passed to the SUBST

JackO
10/29/2007 12:18:00 PM

sql server dts:

I am trying to run an SSIS package from SQL Server 2005 Standard Edition with
SP2 and I am getting the following error: 'SQLServer Error: 536, Invalid
length parameter passed to the SUBSTRING function. [SQLSTATE 42000]'. I am
storing the packages in the SQL Server database and I have setup credentials
for a user called 'PDAT' and have setup a Proxy using the credentials of the

Re: SQLServer Error: 536, Invalid length parameter passed to the SUBST

jhofmeyr NO[at]SPAM googlemail.com
10/29/2007 11:19:52 PM

[quoted text, click to view]

Hi JackO,

Is this error occurring before the package has even run? Do you have
package logging enabled, and if yes, is it logging anything? What
command are you using to run the package? And finally, does the
package execute correctly if you open it in VS and run it manually
using your credentials?

Regards,
J