|
|
-
Madhivanan Commented 3 Months ago through Blogs | 1 Point
Bala Krishna, EXCEL can be dealt with easily using EXCEL as the source and OLE DB as the destination...
|
|
|
-
Madhivanan Posted 3 Months ago through Blogs | 10 Points
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 3 Months ago through Blogs | 1 Point
Did you mean total for each pivot columns?...
|
-
Madhivanan Commented 3 Months ago through Blogs | 1 Point
albertsmus, see if this helps http://beyondrelational.com/modules/2/blogs/70/posts/10812/select-columns-from-exec-procedurename-is-this-possible.aspx...
|
|
|
-
Madhivanan Posted 3 Months ago through Blogs | 10 Points
When you run the following codeselect name from sys.objects
having 1=1
you get the following error Msg 8120, Level 16, State 1, Line 2
Column 'sys.objects.name' is invalid in the select list because it is not contained in either an aggregate function or...
|
-
Madhivanan Commented 3 Months ago through Blogs | 1 Point
Bala krishna, yes you can make use of that option too....
|
|
|
-
Madhivanan Posted 3 Months ago through Blogs | 10 Points
Previous post on this series
Exploring SSIS - Understanding the basics Exploring SSIS - Execute SQL task with simple parameter Exploring SSIS - Export to csv file
I have started a series on Exploring SSIS where I will explain various features available....
|