CODEWITHSUNDEEP
sqlsql-serversql-server-2008ssissql-server-2008-r2
mehdi lotfi
mehdi lotfi

Reputation: 11571

Create Job To Convert Data With SSIS

I Want To Convert Data From OldDatabase To NewDatabase Each Day By SSIS. for this:

1- Create Script From Exists New DataBase
2- Change DatabaseName OF Generated Script and Then Execute Script To Create NewDatabase2 whit no data.
3- Set SSIS Configuration Parameters.
4- Execute SSIS Package to convert Data.

I Want to do this action by Job. How I want to do?

Upvotes: 1

Views: 77

Answers (1)

Diego
Diego

Reputation: 36146

your requiremets are not very clear but there are two SSIS tasks that can help you.

If you want to transfer all you can use a "Transfer Database Task"

If you need to specify objects, you can use the "Transfer SQL Server Objects Task" where you can specify things like if you are dropping the objects first and how to deal with the data:

enter image description here

Upvotes: 2

Related Questions