Sqlism (10/15/2012)

---

Thanks for the reply ron,

I am expecting a script, not thru GUI

Thanks again :)

You can also decide whether to save the package to SQL Server or to the file system. If you select to save the package, you must also specify a package protection level. For more information about package protection levels, see Setting the Protection Level of Packages.

After the SQL Server Import and Export Wizard has created the package and copied the data, you can use the SSIS Designer to open and change the saved package.

CSV FILE : Test.csv
a,b
1,A
2,B
3,C

create table #test(a int,b varchar)

BULK INSERT #test1
   FROM 'C:\Test.csv'
   WITH 
      (
         FIELDTERMINATOR =',',
         ROWTERMINATOR =' ',
         FIRSTROW = 2
      )