|
|
-
Madhivanan Posted 4 Months ago through Blogs
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 4 Months ago through Blogs
Bala krishna, yes you can make use of that option too....
|
|
|
-
Madhivanan Posted 4 Months ago through Blogs
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....
|
|
|
-
Madhivanan Commented 4 Months ago through Blogs
> Even more impressive then, ol' friend.
> Learn it, use it, share it, repeat as
> necessary. You're definitely one of
> the good guys, Madhivanan. It's an
> honor to have known you these many
> years.
Thanks Jeff Moden for your kind words. I am...
|
-
Madhivanan Commented 4 Months ago through Ask
Which version of SQL Server are you using? I think the MAX on VARCHAR does the implicit integer convertion. But I do not see this behaviour in 2012 Express edition...
|
|
|
-
Madhivanan Commented 4 Months ago through Blogs
Thanks Jeff Moden. I would also prefer using BCP. One of our customers wanted to build ETL solution fully using SSIS only. So I thought of showing SSIS's way of doing this :)...
|
-
Madhivanan Commented 4 Months ago through Blogs
Thanks Arun and Bala Krishna for your feedbacks...
|