January 17, 2008 at 3:28 pm
i was not sure whether to post this under Integration Service or under Business Intelegence Fourms, however it posted here anyway. My SSIS packages which has 5 child packages and it restores databases on the different servers. My databases are on 2 different server. one 2005 and other 2000 with two instances. i have connection string for both of the server. on my fist child packages it tries to drop the publications using store procedure. whcih is DECLARE @Error INT
IF EXISTS(SELECT * FROM dbname.dbo.sysobjects WHERE [name] = 'syssubscriptions' and type = 'U')
BEGIN
IF EXISTS (SELECT * FROM dbaname.dbo.syssubscriptions)
BEGIN
EXEC dbname.dbo.sp_dropsubscription @publication = 'all', @article = 'all',@subscriber = 'all'
SET @Error = @@Error
IF @Error <> 0
RAISERROR(@Error, 16, 10)
END
END
IF EXISTS(SELECT * FROM dbname.dbo.sysobjects WHERE [name] = 'syspublications' and type = 'U')
BEGIN
IF EXISTS (SELECT * FROM dbname.dbo.syspublications)
BEGIN
EXEC dbname.dbo.sp_droppublication @publication = 'all'
SET @Error = @@Error
IF @Error <> 0
RAISERROR(@Error, 16, 10)
END
END
however when i try to execute the packages gives me error....saying cannot find the objects "dbname.dbo.sysobjects"
am i doing anything wrong..
January 18, 2008 at 1:43 pm
anyone got any idea...looks like to me connection manager error . but can't seem to find the ways to get around this,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply