DTS- Integration with Excel
This is to automate an entire task of getting data from a text file, import to a table in SQL Database and create a pivot table out of it(In Excel)
The process is as follows:
Process-1:
Truncate table(if exists) -- Open Text file --Import data from text file to a SQL Database after completing some business logic - Update the table in SQL Db
Process-II
Use updated table to create pivot table in excel and then a pivot chart
Instead of doing the two step process as given above, this has to get executed as a single step.
Please share if you have any solutions on the same.
|
