Import Data Problems

[OAKEJ]

I'm fairly new to SQL Server 2005. I imported a Table, made a package that queries the data from the imported table, however when the package runs in the nightly refresh it runs the query but doesn't update the imported table data. Has anyone run into this before. The package is debugged and finishes with success. Any help would be greatly appreciated. Thanks

 

[SQLSister]

What is the query?

"NOTHING is more important in a database than integrity." ESquared

 

[OAKEJ]

USE BI_TEMP
GO
--
TRUNCATE TABLE
DBO.OAKEJ_LSSMETRICV
GO
--
INSERT INTO
DBO.OAKEJ_LSSMETRICV
--
SELECT *
--
FROM
DBO.ATHOMM_LSSMETRICV *******Imported Source Table
---------------------------------------------------------------------------------------------------------
--
IF (SELECT OBJECT_ID ('BI_TEMP.dbo.Shop_LSSMETRICS')) IS NOT NULL
BEGIN
DROP TABLE BI_TEMP.dbo.Shop_LSSMETRICS
END
---------------------------------------------------------------------------------------------------------
SELECT
Regions
,Site
,SHOP_Desc
,Cast(Cast(rptdate as Varchar(8))as smalldatetime) as Report_Date
,jobtime
,dwellhours
,productvty
,pmfailcnt
,getdate() as Log_Date

INTO BI_TEMP.dbo.Shop_LSSMETRICS

FROM BI_TEMP.dbAKEJ_LSSMETRICV Metrics left join
BI_Temp.dbAKEJ_Shop_Master_List Master_List
on Metrics.oasite = Master_List.Site

WHERE
Month(Cast(Cast(rptdate as Varchar(8))as smalldatetime))=Month(GetDate())

Order by
Regions
,Site
,rptdate

 

[SQLSister]

run just this part
SELECT *
--
FROM
DBO.ATHOMM_LSSMETRICV *******Imported Source Table
I think you forgot to comment out from the space on.

"NOTHING is more important in a database than integrity." ESquared