Hello,

I am new to SSIS, any help is greatly appreciated.

I need to convert a few DTS packages that manupulate excel files to
SSIS. In DTS, I used vbscript task to open excel, insert data from
database, format the data, and save the file. How can I do this in
SSIS? Is it possible? What's the best pratice on this kind of
manipulation in SSIS?

Thanks in Advance.

AC.

It sounds like you need to look up some information on the Excel Destination
Function of the DataFlow Element in SSIS....


--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/


"Grasshopper" <amlchow (AT) gmail (DOT) com> wrote

http://msdn2.microsoft.com/en-us/library/ms137643.aspx

Here is some information on the excel desitination funcitonality of the
dataflow element of SSIS.
Basically you are going to grab your data, do your manipulation using one of
the data transformers and then dump the data into an excel file.
I dont see why you would, but you could reopen the excel using an excel
source and manipulate the data again using sql commands.

thanks,

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/


"Grasshopper" <amlchow (AT) gmail (DOT) com> wrote