|
|
-
Madhivanan Posted 3 Months ago through Blogs
BCP is one of the fastest methods to export data to various formats like csv,txt,etc and doing this in a command mode is faster than doing it via SSMS.
Let us create this simple tablecreate table test(iud int, name varchar(50))
insert into test(id,name...
|
|
|
|
|
-
Madhivanan Posted 4 Months ago through Blogs
Import dataChoose Data source as Flat file source, browse the file, Under the Data source tab, choose the columns and make sure that Row delimiter is {CR}{LF} and column delimiter as Vertical Bar {|}, click next and choose the d...
|
-
Madhivanan Commented 4 Months ago through Blogs
Bala Krishna, EXCEL can be dealt with easily using EXCEL as the source and OLE DB as the destination...
|
|
|
-
Madhivanan Posted 4 Months ago through Blogs
Previous posts on this series
Exploring SSIS - Understanding the basics Exploring SSIS - Execute SQL task with simple parameter Exploring SSIS - Export to csv file Exploring SSIS - Rename file by suffixing current date
I have started a series on Exp...
|
-
Madhivanan Commented 4 Months ago through Blogs
Did you mean total for each pivot columns?...
|
-
Madhivanan Commented 4 Months ago through Blogs
albertsmus, see if this helps http://beyondrelational.com/modules/2/blogs/70/posts/10812/select-columns-from-exec-procedurename-is-this-possible.aspx...
|
|
|