What im trying to do is if i have two database tables with the same "field" names i would like to be able to take the data from the field names and insert them into a CSV file with just one set of headings for example if i had
Column 1 Column 2
In one table and...
Column 1 Column 2 (NOTE THAT THE COLUMNS ARE SAME NAME)
to make it do a loop for all tables within that database and insert all "Column 1 and column 2" data into one two headings in the CSV file..
If this is possible i really dont know which is why i turned to the guys that know best.
Thank you for your help it is always apprciated in any form.
So the ouput in the CSV i would like is as follows
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…