This is the last piece of my project (at least I hope
so). Thanks to this board I got many usefull answers and
I hope you guys can help me one more time.

SQL 2K - I would like to have one DTS that can do the
following

1) based on the global param execute a specific storedProc
(which might be on different tables) and export that data
to the bcp file

how do i make transformations values dymanic. right now
it seems to be taking the values for my columns from the
first table... i want those to change based on my param

is that possible?
how?

i really don't want to have 20 DTSs that basically do
exactly the same thing except that data is different.

thanks a lot,
branka

OK so you want to use BCP dynamically and export whatever you pass in

What about this task

Bulk Export Task
(http://www.sqldts.com/Default.aspx?237)

You can dynamically build a BCP statement and execute a stored proc to
export to text file easily

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)

--

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


"branka" <anonymous (AT) discussions (DOT) microsoft.com> wrote