Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dev@nlkss
134 Posts |
 Posted - 2009-01-13 : 04:29:07
|
| Hi AllI am new to SSIS.I have created a SSIS Package for loading table data from one server to another using BIDS.Its working fine manually but i want to make it as SQL Job.Can Anybody tell me how to create a job using SSIS Package.and One more thing how can i make sure only modified and new records can be inserted from second time onwards.its urgentthanks in advance.Satya |
|
|
Nagaraj
Starting Member
14 Posts |
Posted - 2009-01-15 : 04:16:48
|
| Hi Satya,For creating a job go through the following link [url]http://www.mssqltips.com/tip.asp?tip=1180[/url]For the second scenario there are two possible ways.1. you need to use lookup functionality to check for new records.2. If you have any column by which you can identify the new records,then you can write a query based on that column. So that new records will be retrieved.Nagaraj. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 07:34:03
|
quote:
Originally posted by satya@imi
Hi AllI am new to SSIS.I have created a SSIS Package for loading table data from one server to another using BIDS.Its working fine manually but i want to make it as SQL Job.Can Anybody tell me how to create a job using SSIS Package.and One more thing how can i make sure only modified and new records can be inserted from second time onwards.its urgentthanks in advance.Satya
modified and new records (delta changes) can be picked easily by using an audit column like datemodified or by using a slowly changing dimension task. the former one requires you to store max date of records processed during each run and log it to table. next time retrieve the max date from table and look for records with date > extracted date.For using SCD task, you just need to give a key with type of analysis needed (type 1 or type 2). type 1 is one where you just keep on updating modified data and inserting new data while type 2 you will insert everything as new record with a bit field representing recent record. |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2009-01-16 : 02:41:36
|
| Thanks for informationI dont have any column as lastupdatedOn.How to use lookup functionalitycan u tell me some detail.thanksSatya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
SQL Server Integration Services