Dear Experts..

How can I Transfer data from sql server table to excel
file programatically in DTS activex script??


1)Table data need to fetch from a sql querry that change
every time the Package is excuted i.e I want to pass the
sql querry(with lots of joins) every time the packeage is
excuted

2)Target excel file name should be created dynamically.

Basically what I want is , end user will select options
from web page, what data he needs to be exported to excel
file ,depending on their options I will build a sql querry
on web page and using stored procedure and/or DTS and sql
statement , I want to export that data to excel file
saving the file with endusername.


any help will be greately appriciated


thanks
Sai

You can

1. Parse the columns that the user wants from his SELECT criteria.
2. Create an Excel table from that using a CREATE TABLE Statement against
an Excel Connection
3. Enter the statement as the SourceSQLStatement of the DataPump task
4. Dynamically create the transformations.
5. pump the data

This will take a bit of setting up but you should be able to do it.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"gsv" <reddyg (AT) hotmail (DOT) com> wrote

Hello, Sai!

I have a package at home that does this with a simple select statement so
mail me provately to remind me and I shall send it on.


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

: Thank you very much again for taking time to help me

: ---
: sai
??>> -----Original Message-----
??>> You can
??>>
??>> 1. Parse the columns that the user wants from his SELECT
: criteria.
??>> 2. Create an Excel table from that using a CREATE TABLE
: Statement against
??>> an Excel Connection
??>> 3. Enter the statement as the SourceSQLStatement of the
: DataPump task
??>> 4. Dynamically create the transformations.
??>> 5. pump the data
??>>
??>> This will take a bit of setting up but you should be able
: to do it.
??>>
??>> --
??>>
??>> Allan Mitchell (Microsoft SQL Server MVP)
??>> MCSE,MCDBA
??>> www.SQLDTS.com
??>> I support PASS - the definitive, global community
??>> for SQL Server professionals - http://www.sqlpass.org
??>>
??>> "gsv" <reddyg (AT) hotmail (DOT) com> wrote in message
??>> news:411f01c3409e$c1e2e9f0$a401280a (AT) phx (DOT) gbl...
??>>> Dear Experts..
??>>>
??>>> How can I Transfer data from sql server table to excel
??>>> file programatically in DTS activex script??
??>>>
??>>> 1)Table data need to fetch from a sql querry that change
??>>> every time the Package is excuted i.e I want to pass the
??>>> sql querry(with lots of joins) every time the packeage
: is
??>>> excuted
??>>>
??>>> 2)Target excel file name should be created dynamically.
??>>>
??>>> Basically what I want is , end user will select options
??>>> from web page, what data he needs to be exported to
: excel
??>>> file ,depending on their options I will build a sql
: querry
??>>> on web page and using stored procedure and/or DTS and
: sql
??>>> statement , I want to export that data to excel file
??>>> saving the file with endusername.
??>>>
??>>> any help will be greately appriciated
??>>>
??>>> thanks
??>>> Sai
??>>>
--- Microsoft CDO for Windows 2000

Hi
Alan
You are my life saver........ I am realy
very thank full to you for your kind help,

Please send me the package that accomplish the task ,I
tried to send a request to your mail id allan@no-
spam.sqldts.com, which was bounced back to me,please send
me the Package to my mail id saivishnu (AT) hotmail (DOT) com


With regards

Sai