Avatar of PKTG
PKTG
Flag for United States of America

asked on 

How to delete different database table records via SSIS?

I want to delete 30 days old data from different database table. All database in same server.  I like to do this task via SSIS and schedule the job. I thought i can write the below script in one execute sql task . But in connection manager i can give only one database. I don't know how to pass  different database in connection manager. Pls help me.

DELETE FROM db1..table1 WHERE convert(varchar,starttime,112)<convert(varchar,dateadd(dd,-30,getdate()),112)
DELETE FROM db2..table2 WHERE convert(varchar,starttime,112)<convert(varchar,dateadd(dd,-30,getdate()),112)
DELETE FROM db3..table3 WHERE convert(varchar,starttime,112)<convert(varchar,dateadd(dd,-30,getdate()),112)
DELETE FROM db4..table4 WHERE convert(varchar,starttime,112)<convert(varchar,dateadd(dd,-30,getdate()),112)
Microsoft SQL ServerMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
PKTG

8/22/2022 - Mon