Can we insert one Source row ,multiple times on the
destination usind DAta Driven Query task or Tranform Data
task.

If thers 1 row on the source ,I want to insert 4 or more
on the destination with the sane value . IS that possible.

Plz let me know its urgent

BAbu

Yes it is

You use a counter and a return status of

MAIN = DTSTransformStat_SkipFetch

pretty much like in this article

Processing The Same Row More Than Once
http://www.sqldts.com/default.aspx?6,103,266,0,1


--

----------------------------
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



"Babu" <Gaj_babu (AT) hotmail (DOT) com> wrote