I have a package which loads data from table to excel.but in excel destination (i.e server) Ms office is not installed.I want to load the data to excel without ms office being installed onto the server. fuzailrashid

You can't use excel features without installing MS office because you need to add COM referenece to your project. Work Around: Save your Excel data as CSV (comma separated value) files with SSIS. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/

is there any dll or directory that generates excel file without office being installedfuzailrashid

is there any dll or directory that generates excel file without office being installed fuzailrashid Please check this blog.. you can install the derives.. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/

is there any dll or directory that generates excel file without office being installed fuzailrashid There are a few commercial components, but they will cost you about the same as an Office installation... and they required .net knowledge (Script Component). The CSV workaround is a better solution. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

The CSV workaround is a better solution. I dont understand how to do this.fuzailrashid

The CSV workaround is a better solution. I dont understand how to do this. fuzailrashid Just use a flat file destination instead of an excel destination. Give it the extension .csv and use delimiter (, or ;)instead of fixed width. The only drawback of this workaround is that you can't have multiple tabs. But the csv opens in excel and looks like a worksheet: test Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

in csv file the column data are scattered i.e in column a if the data is no1,cross road , in excel it appears as two column how to avoid itfuzailrashid

The Text Qualifier option allows you to specify that character data is wrapped in quotes or some type of qualifier. This helps you when you have a file that is delimited by commas, and you also have commas inside some of the text data that you do not wish to separate by. Setting a Text Qualifier will ignore those commas inside the text data.Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/