CODEWITHSUNDEEP
ssis
Sarathy
Sarathy

Reputation: 452

Bulk Insert in SSIS 2008

I need to extract data from particular database and import it into another database. Both the source and destination DB are SQL server.Source DB retrive more than 510,000 records. But Bulk insert allow only flat file source in SSIS.

Which method is suitable in this case? Kindly help me

Upvotes: 0

Views: 843

Answers (1)

grapefruitmoon
grapefruitmoon

Reputation: 3008

You need to use a Data Flow Task. This will allow you create a source and destination of SQL Server. Look at the OleDb source/destinations. In a data flow you can also perform any transformations or processing that you may require.

Upvotes: 1

Related Questions