SQL Server export via Linked server

--DROP TABLES ON DWSQLDB
SELECT getdate() 'Drop Destination Tables at DWSQLDB'

EXECUTE ('DROP TABLE [SRC_CRM].[dbo].[B_RPT_CM_CONTACT_PH_EML_TBL]') AT DWSQLDB;

EXECUTE ('DROP TABLE [SRC_CRM].[dbo].[B_RPT_CONTACT_ROLE_TBL]') AT DWSQLDB;

EXECUTE ('DROP TABLE [SRC_CRM].[dbo].[PS_BO_ROLE_TYPE_VW]') AT DWSQLDB;

EXECUTE ('DROP TABLE [SRC_CRM].[dbo].[PS_CUSTOMER]') AT DWSQLDB;

EXECUTE ('DROP TABLE [SRC_CRM].[dbo].[PS_RC_CUSTOMER_VW]') AT DWSQLDB;

EXECUTE ('DROP TABLE [SRC_CRM].[dbo].[PS_RD_COMPANY]') AT DWSQLDB;

-- CREATE TABLES ON DWSQLDB
SELECT getdate() 'Create Tables on DWSQLDB'
GO

EXECUTE (
        'CREATE TABLE "SRC_CRM".."B_RPT_CM_CONTACT_PH_EML_TBL"(
        "COMPANYID" [nvarchar](15) NOT NULL,
        "PERSON_ID" [nvarchar](15) NOT NULL,
        "BO_ID_CONTACT" [decimal](31, 0) NOT NULL,
        "BO_ID_CUST" [decimal](31, 0) NOT NULL,
        "PHONE" [nvarchar](35) NULL,
        "EMAIL" [nvarchar](70) NULL
)'
        ) AT DWSQLDB;
GO

EXECUTE (
        'CREATE TABLE "SRC_CRM".."B_RPT_CONTACT_ROLE_TBL"(
        "COMPANYID" [nvarchar](15) NOT NULL,
        "BO_ID_CUST" [decimal](31, 0) NOT NULL,
        "BO_ID" [decimal](31, 0) NOT NULL,
        "PERSON_ID" [nvarchar](15) NOT NULL,
        "LAST_NAME" [nvarchar](30) NOT NULL,
        "FIRST_NAME" [nvarchar](30) NOT NULL,
        "MIDDLE_NAME" [nvarchar](30) NOT NULL,
        "TITLE" [nvarchar](35) NOT NULL,
        "ROLE_TYPE_ID" [decimal](12, 0) NOT NULL,
        "Contact Role Descr" [nvarchar](30) NOT NULL
)'
        ) AT DWSQLDB;
GO

EXECUTE (
        'CREATE TABLE "SRC_CRM".."PS_BO_ROLE_TYPE_VW"(
    "ROLE_TYPE_ID" [decimal](12, 0) NOT NULL,
    "BO_TYPE_ID" [int] NOT NULL,
    "DESCR" [nvarchar](30) NOT NULL,
    "DESCRSHORT" [nvarchar](10) NOT NULL
)'
        ) AT DWSQLDB;
GO

EXECUTE (
        'CREATE TABLE "SRC_CRM".."PS_CUSTOMER"(
    "SETID" [nvarchar](5) NOT NULL,
    "CUST_ID" [nvarchar](15) NOT NULL,
    "CUST_STATUS" [nvarchar](1) NOT NULL,
    "CUST_STATUS_DT" [datetime] NULL,
    "CUSTOMER_TYPE" [nvarchar](1) NOT NULL,
    "SINCE_DT" [datetime] NOT NULL,
    "ADD_DT" [datetime] NOT NULL,
    "NAME1" [nvarchar](50) NOT NULL,
    "NAMESHORT" [nvarchar](10) NOT NULL,
    "NAME1_AC" [nvarchar](40) NOT NULL,
    "ADDRESS_SEQ_NUM" [int] NOT NULL,
    "CORPORATE_SETID" [nvarchar](5) NOT NULL,
    "CORPORATE_CUST_ID" [nvarchar](15) NOT NULL,
    "CNTCT_SEQ_NUM" [int] NOT NULL,
    "SUBCUST_USE" [nvarchar](1) NOT NULL,
    "CUR_RT_TYPE" [nvarchar](5) NOT NULL,
    "CURRENCY_CD" [nvarchar](3) NOT NULL,
    "VAT_TXN_TYPE_CD" [nvarchar](4) NOT NULL,
    "SHIP_TO_FLG" [nvarchar](1) NOT NULL,
    "BILL_TO_FLG" [nvarchar](1) NOT NULL,
    "SOLD_TO_FLG" [nvarchar](1) NOT NULL,
    "BROKER_FLG" [nvarchar](1) NOT NULL,
    "INDIRECT_CUST_FLG" [nvarchar](1) NOT NULL,
    "CUST_LEVEL" [nvarchar](1) NOT NULL,
    "ADDRESS_SEQ_SOLD" [int] NOT NULL,
    "CNTCT_SEQ_SOLD" [int] NOT NULL,
    "ADDRESS_SEQ_SHIP" [int] NOT NULL,
    "CNTCT_SEQ_SHIP" [int] NOT NULL,
    "ADDRESS_SEQ_BRK" [int] NOT NULL,
    "ADDRESS_SEQ_IND" [int] NOT NULL,
    "HOLD_UPDATE_SW" [nvarchar](1) NOT NULL,
    "TAXPAYER_ID" [nvarchar](14) NOT NULL,
    "WEB_URL" [nvarchar](130) NOT NULL,
    "STOCK_SYMBOL" [nvarchar](10) NOT NULL,
    "LAST_MAINT_OPRID" [nvarchar](30) NOT NULL,
    "DATE_LAST_MAINT" [datetime] NULL
)'
        ) AT DWSQLDB;
GO

EXECUTE (
        'CREATE TABLE "SRC_CRM".."PS_RC_CUSTOMER_VW"(
    "SETID" [nvarchar](5) NOT NULL,
    "BO_ID" [decimal](31, 0) NOT NULL,
    "ROLE_TYPE_ID" [decimal](12, 0) NOT NULL,
    "BO_NAME" [nvarchar](50) NULL
)'
        ) AT DWSQLDB;

EXECUTE (
        'CREATE TABLE "SRC_CRM".."PS_RD_COMPANY"(
    "SETID" [nvarchar](5) NOT NULL,
    "COMPANYID" [nvarchar](15) NOT NULL,
    "BO_ID" [decimal](31, 0) NOT NULL,
    "DUNS_NUMBER" [nvarchar](20) NOT NULL,
    "INDUSTRY_ID" [nvarchar](30) NOT NULL,
    "COUNTRY" [nvarchar](3) NOT NULL,
    "STATE_INCORPORATED" [nvarchar](6) NOT NULL,
    "TAXPAYER_ID" [nvarchar](14) NOT NULL,
    "CUSTOMER_TYPE" [nvarchar](1) NOT NULL,
    "CONSOL_BUS_UNIT" [nvarchar](5) NOT NULL,
    "BO_ID_PARENT" [decimal](31, 0) NOT NULL,
    "WEB_URL" [nvarchar](130) NOT NULL,
    "SIC_TYPE" [nvarchar](10) NOT NULL,
    "SIC_CODE" [nvarchar](10) NOT NULL,
    "INDUSTRY_ID2" [nvarchar](30) NOT NULL,
    "LOC_TYPE" [nvarchar](4) NOT NULL,
    "BUSINESS" [nvarchar](4) NOT NULL,
    "EMPL_TOTAL" [int] NOT NULL,
    "SOURCE_IND" [nvarchar](4) NOT NULL,
    "LEGAL_STRUCTURE" [nvarchar](1) NOT NULL,
    "OWNERSHIP" [nvarchar](4) NOT NULL,
    "YEAR_STARTED" [smallint] NOT NULL,
    "YEAR_INCORPORATED" [smallint] NOT NULL,
    "MINORITY_OWNED_IND" [nvarchar](1) NOT NULL,
    "PARTNER_IND" [nvarchar](1) NOT NULL,
    "FISCAL_YEAR_END" [datetime] NULL,
    "STATEMENT_IND" [nvarchar](1) NOT NULL,
    "STATEMENT_DT" [datetime] NULL,
    "AUDIT_IND" [nvarchar](1) NOT NULL,
    "AUDITOR_NAME" [nvarchar](50) NOT NULL,
    "STOCK_SYMBOL" [nvarchar](10) NOT NULL,
    "STOCK_EXCHANGE" [nvarchar](10) NOT NULL,
    "STOCK_PRICE" [decimal](15, 4) NOT NULL,
    "MARKET_CAP" [decimal](26, 3) NOT NULL,
    "QUOTE_DT" [datetime] NULL,
    "NET_INCOME" [decimal](26, 3) NOT NULL,
    "TOTAL_ASSETS" [decimal](26, 3) NOT NULL,
    "TOTAL_LIABILITIES" [decimal](26, 3) NOT NULL,
    "ACCTS_PAYABLE" [decimal](26, 3) NOT NULL,
    "ACCTS_RECEIVABLE" [decimal](26, 3) NOT NULL,
    "NET_WORTH" [decimal](28, 4) NOT NULL,
    "CREDIT_RATING" [nvarchar](4) NOT NULL,
    "CURRENCY_CD" [nvarchar](3) NOT NULL,
    "REVENUE" [nvarchar](4) NOT NULL,
    "REVENUE_GEN" [decimal](26, 3) NOT NULL,
    "MARKET" [nvarchar](3) NOT NULL,
    "ROW_ADDED_DTTM" [datetime] NULL,
    "ROW_ADDED_OPRID" [nvarchar](30) NOT NULL,
    "ROW_LASTMANT_DTTM" [datetime] NULL,
    "ROW_LASTMANT_OPRID" [nvarchar](30) NOT NULL,
    "SYNCID" [int] NULL,
    "SYNCDTTM" [datetime] NULL,
    "B_PAYMENT_STATUS" [nvarchar](2) NOT NULL,
    "PSYESNO" [nvarchar](4) NOT NULL,
    "PERSON_ID" [nvarchar](15) NOT NULL,
    "PERSON_ID2" [nvarchar](15) NOT NULL
)'
        ) AT DWSQLDB;

-- Export Tables
SELECT getdate() 'B_RPT_CM_CONTACT_PH_EML_TBL'
GO

INSERT INTO openquery (
    DWSQLDB
    ,'SELECT * FROM SRC_CRM..B_RPT_CM_CONTACT_PH_EML_TBL'
    )
SELECT *
FROM CRMRPT..B_RPT_CM_CONTACT_PH_EML_TBL
GO

SELECT getdate() 'Start BRPT_CONTACT_ROLE_TBL export'
GO

INSERT INTO openquery (
    DWSQLDB
    ,'SELECT * FROM SRC_CRM..BRPT_CONTACT_ROLE_TBL'
    )
SELECT *
FROM CRMRPT..BRPT_CONTACT_ROLE_TBL
GO

SELECT getdate() 'Start PS_BO_ROLE_TYPE_VW export'
GO

INSERT INTO openquery (
    DWSQLDB
    ,'SELECT * FROM SRC_CRM..PS_BO_ROLE_TYPE_VW'
    )
SELECT *
FROM CRMRPT..PS_BO_ROLE_TYPE_VW
GO

SELECT getdate() 'Start PS_CUSTOMER export'
GO

INSERT INTO openquery (
    DWSQLDB
    ,'SELECT * FROM SRC_CRM..PS_CUSTOMER'
    )
SELECT *
FROM CRMRPT..PS_CUSTOMER
GO

SELECT getdate() 'Start PS_RC_CUSTOMER_VW export'
GO

INSERT INTO openquery (
    DWSQLDB
    ,'SELECT * FROM SRC_CRM..PS_RC_CUSTOMER_VW'
    )
SELECT *
FROM CRMRPT..PS_RC_CUSTOMER_VW
GO

SELECT getdate() 'Start PS_RD_COMPANY export'
GO

INSERT INTO openquery (
    DWSQLDB
    ,'SELECT * FROM SRC_CRM..PS_RD_COMPANY'
    )
SELECT *
FROM CRMRPT..PS_RD_COMPANY
GO