Import data is not overwriting my tables(2 out of 4 jobs work??)
I am importing data from 4 views into my test database. I created them all the same, uses File System, no encryption. 2 of them overwrite the tables and 2 of them fail because it says the object exists. I've recreated these jobs a couple of times and I don't understand why 2 work and 2 wont'? Any clue would help.. There isn't a way to say overwrite in the Import package is there? Do I need to add a TSQL step to drop the table? I will try that but help would be appreciated. Pat PatM Reno
March 15th, 2011 12:05pm

depends on what are you trying to achieve? do you want to keep destination data or not?If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2011 12:30pm

no I want it to overwrite all 4. 2 work and 2 don't. I just tried adding a step before the import to Drop the table but it's telling me it's not doing the 1st step.??PatM Reno
March 15th, 2011 12:33pm

no I want it to overwrite all 4. 2 work and 2 don't. I just tried adding a step before the import to Drop the table but it's telling me it's not doing the 1st step.?? PatM Reno what's your first step? Try as IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[YOUR_SCHEMA_NAME].[YOUR_TABLE_NAME]') AND type in (N'U')) DROP TABLE [YOUR_SCHEMA_NAME].[YOUR_TABLE_NAME] GOIf you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2011 12:40pm

no I want it to overwrite all 4. 2 work and 2 don't. I just tried adding a step before the import to Drop the table but it's telling me it's not doing the 1st step.?? PatM Reno what's your first step? Try as IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[YOUR_SCHEMA_NAME].[YOUR_TABLE_NAME]') AND type in (N'U')) DROP TABLE [YOUR_SCHEMA_NAME].[YOUR_TABLE_NAME] GOIf you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com
March 15th, 2011 12:40pm

Drop all tables and recreate them(T-SQL script) before import the data
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2011 12:43pm

I simply inserted step above my import file package, DROP TABLE UTCustomerData.dbo.vw_RNO_RoutesBooksAccounts_plm ; Then I get a warning: The following steps cannot be reached with the current job step flow login. In the old DTS you used to be able to simply flow things. Amazing how things get worse instead of better. PatM Reno
March 15th, 2011 12:52pm

I simply inserted step above my import file package, DROP TABLE UTCustomerData.dbo.vw_RNO_RoutesBooksAccounts_plm ; Then I get a warning: The following steps cannot be reached with the current job step flow login. In the old DTS you used to be able to simply flow things. Amazing how things get worse instead of better. PatM Reno
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2011 12:52pm

I will try this too. thanks Pat PatM Reno
March 15th, 2011 12:52pm

I will try this too. thanks Pat PatM Reno
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2011 12:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics