August 28, 2008 at 10:08 am
All, I want to create an SSIS package to replace a job that consist of 2 steps.
Step 1) = Insert data from one table to another table.
INSERT INTO TEST2
(IPAdd,BrowserName,BrowserVer)
SELECT
BrowserName,BrVer,BVer
FROM dbo.TEST(NOLOCK)
WHERE
DateDiff(d,DateAdd(d,-1,GetDate()),DateTimeStamp)=0
Step 2) = Delete moved data from orignal table
DELETE FROM Test2
WHERE
DateDiff(d,DateAdd(d,-1,GetDate()),DateTimeStamp)=0
Please advise me that how i can create such a SSIS package which will perform the following tasks.
Thanks.... ALL
AR
August 28, 2008 at 11:00 am
You can use execute sql task, which executes sql statements inside the task.
VG
August 28, 2008 at 1:40 pm
I can do the 2nd Step while using the SQL Task. But i dont knonw that how i can move the data which i mention in Step 1.
August 28, 2008 at 1:51 pm
For that you need data flow task, and define your source and destination connections and map the columns between source and destination.
VG
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply