used 3 tables it have millions record. so last 3 year before data move source to stg table and then stg to archival and delete record from source and stg table after moved archival (source and stg table same server but archival is different server). How to create siss package. please make one video.
If your source table have a datetime field where you are storing the date value then you can easily select last 3 years of data using a where clause something below where datefield > DATEADD(year,-3,GETDATE()) you can select the data using a data flow task, in the source you can use an oledb source and write a select query and then move it to a sql table using OLEDB Destination. Later you can use an execute sql task to delete the data, you can put the same where clause while deleting data delete from table where datefield > DATEADD(year,-3,GETDATE())
can you use the msdb database to get schedule details for sql agent jobs as well? Like daily, weekly, monthly jobs?
Yeah we can get the details of all the scheduled jobs from msdb database.
Hi, can you pls tell me how to upload files into sftp server by using psftp.exe or winscp.exe? I want to upload files without using c# code.
Okay, I would need to check that one.
I believe the first three ones could be very well packed into one and maybe still exist due to backward compatibility.
Yeah you are right.
used 3 tables it have millions record. so last 3 year before data move source to stg table and then stg to archival and delete record from source and stg table after moved archival (source and stg table same server but archival is different server). How to create siss package. please make one video.
If your source table have a datetime field where you are storing the date value then you can easily select last 3 years of data using a where clause something below
where datefield > DATEADD(year,-3,GETDATE())
you can select the data using a data flow task, in the source you can use an oledb source and write a select query and then move it to a sql table using OLEDB Destination.
Later you can use an execute sql task to delete the data, you can put the same where clause while deleting data
delete from table where datefield > DATEADD(year,-3,GETDATE())
Sir please cover pivot unpivot and CTE topic people make it very very complex
Okay, will try to make a video on this one.
@@learnssis Thank you😊