Hi
I still have problems with a DTS package.
I have a Table A, where I have the path file to save the file and the ID
company

I need to generate a csv files from a table B for each ID company using its
Path file.
and this job must be scheduled.

Of course, the goal is to use a unique DTS package, and I suppose I have to
use GlobalVariables.
But.. but I tried many options and they don't work.

Thanks for your help.

Stan

OK

1. You need to loop through a global variable rowset picking up the
Filename and ID
2. You set the SourceSQL Statement of a DataPump task to the correct SQL
Statement filtering on the ID (WHERE col = ID)
3. You set the text file connection DataSource property to the Global
variable retrieved
4. You loop

These two articles will help

Looping, Importing and Archiving
(http://www.sqldts.com/Default.aspx?246)

How to loop through a global variable Rowset
(http://www.sqldts.com/Default.aspx?298)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Stan Sainte-Rose" <stan (AT) cyber972 (DOT) com> wrote

This should get you started-

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)


--
Darren Green
http://www.sqldts.com

"Stan Sainte-Rose" <stan (AT) cyber972 (DOT) com> wrote

Wowww.. :-)
I thank you for the urls.
For the loop, I used another proc but this one seems very cool.
But I don't know how to create the package for the export section.
I tried to understand the (http://www.sqldts.com/Default.aspx?246) article
but...

Allan gave me some directions with the following proc but I never knew how
to send the parameters (?) and change the destinations directory for the
export file.

SELECT DISTINCT
A_CLIENTS.idclient,
A_CLIENTS.CLICODE,
A_CLIENTS.CLIEMAIL,
FROM A_CLIENTS
WHERE A_CLIENTS.IDSOCIETE= ?
AND LOGDATE< ?

Stan



"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> a écrit dans le
message de news:uTnLmkp3DHA.2888 (AT) tk2msftngp13 (DOT) phx.gbl...

If you are using SQL Server 2000 then you will have a parameters button on
the Source tab of the datapump. This is where you shoose to map your Global
Variable that you have set from the Rowset so have a look at this article
pages 7 & 8

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277,1)


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Stan Sainte-Rose" <stan (AT) cyber972 (DOT) com> wrote