the best place would to read BOL. you can find about linked servers at

http://msdn.microsoft.com/en-us/library/ms188279.aspx

You can find more details at

koln (8/19/2008)

---

Im trying to export Table A to a csv file format, but I do not see that option anywhere in connection manager, SSIS. I see that you can export...

Hi charles

I agree with you that Import/Export design wizard(s) offer very limited access to all the features of the SSIS packages, but i can't use SSIS in my current process....

good question. was unaware of this function.

I forgot to mention in my earlier post, i also found something strange. A big difference in data when a file is exported from sql server using Import Export Wizard...

Sorry MOH and RML51, i havent seen your posts before posting my results.

MOH:

What if you are importing a file with more than 50 columns? It would be a painful...

I can't spend more time onto this matter. I have tested different scenarios and came to result that there is some sort of bug or missing functionality in Import Export...

any help as not able to sort this matter yet.. 🙁

Hi Krish

If you are not familair with SSIS, you can use BCP to export query results to a csv file. I would recommend to have a script containing your sql...

try this

sqlcmd -S servername -U username -P password -i "D:\MSSQL\MSSQL.1\Scripts\Test1.sql"

sqlcmd -S servername -U username -P password -i "D:\MSSQL\MSSQL.1\Scripts\Test2.sql"

you have to run these from cmdexe. If you want to schedule it,...

i am mainting nearly 10 virtual machines running SQL Server 2005. using virtual server 2005 R2 and pretyy happy with it.

easy to manage and haven't felt any issues with it...

i am not sure about the availability of tool, but you can run a task in sql profiler to capture all the activities on the server. Then you can drill...

nothing in my mind at the moment. would say go google. 🙂

This thread has made my day. thanks for posting all this stuff. 🙂