Viewing 2 posts - 1 through 2 (of 2 total)
http://www.bidn.com/blogs/PatrickLeBlanc/ssis/323/handling-database-mirror-failover-within-an-ssis-package
just give the failover in connection string.
January 21, 2011 at 10:30 am
#1276675
i was using this sql in prod environment.
i also got the same error
invalid length error in substring.
i gave a try catch block inside the sp.
why this error comes ?
July 1, 2009 at 2:14 am
#1018211