Viewing 4 posts - 1 through 4 (of 4 total)
I had a similar problem, but went another route. I placed the DTS package execution in an unscheduled job, the used system procedures to start the job.
October 13, 2003 at 6:55 am
--Here you are. Good luck & have fun.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Test]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Test]
GO
Create Table Test (testfield varchar(25))
GO
if exists...
October 13, 2003 at 6:49 am
Have you considered importing it into Access, splitting the tables, and bringing it back into SQL Server?
July 22, 2003 at 7:33 am
Viewing 4 posts - 1 through 4 (of 4 total)