1. sqldev New Member

   Hi,
   I want to upload the CSV File data into a table. It can be done using SSIS. I would like to know the other options available to do the same.
   In Oracle, we have SQL*Loader available to do the basic data transformation, likewise, what are the utilities available in SQL Server 2008, thank you.
   Regards,
   SQL Dev
   

   sqldev, Jun 16, 2009

   #2
2. FrankKalis Moderator

   You can use OPENDATASOURCE, OPENROWSET, BCP, or BULK INSERT. But in many cases an SSIS package is more convenient.
   

   FrankKalis, Jun 17, 2009

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in