Re: DTSTransformStatus with Active X

#1

Not exactly what you want but this example shows DTSTransformStat_SkipInsert
in use.

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

A related example that may be of use-

DTS How to...Skip Rows during Import
(http://www.databasejournal.com/featu...le.php/1461561)

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

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

Quote:

Hello,

I wish read ALL rows of an Excel datasource then transform ALL data ( rows
--> columns) and finally insert them in my sql database with the same

Active X.

Quote:

I think I must use DTSTransformStat_SkipInsert so as to delay the final
insertion.
So I can read all rows and send them into an array (after transformation :
Excel rows --> Columns of the array and Excel columns--> rows of the array).

But how can I insert each row of this array in my database ?

Quote:

Thanks in advance!

Christine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTSTransformStatus with Active X

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTSTransformStatus with Active X - 06-04-2004 , 03:55 AM