Page 1 of 1
example for sqlsrvrwrite function
Posted: Mon Jan 03, 2011 6:39 am
by navya123
hi all,
how can I insert a row into sqlserver table from a ds job using the function sqlsrvrwrite can any body give an example for that
thanks in advance
Posted: Mon Jan 03, 2011 7:00 am
by chulett
Welcome. Can you please edit your first post and let us know your Release, Job Type and OS? Thanks.
Posted: Mon Jan 10, 2011 4:30 am
by navya123
chulett wrote:Welcome. Can you please edit your first post and let us know your Release, Job Type and OS? Thanks.
it is DS 8.2 parallel job and windows operating sys
Posted: Mon Jan 10, 2011 8:00 am
by chulett
OK, so much for the you edit part... I'll take care of that now. And just so you know, there's no such release as "8.2", they went straight from 8.1 to 8.5.
Posted: Mon Jan 10, 2011 8:09 am
by chulett
As to your question, I'm curious how you would handle this outside of DataStage? And I'm also wondering what is the goal here and why you'd need to do such a thing in an ETL tool? From a quick google:
SqlServerWriter: The SqlServerWriter writer is a VSS (Volume Shadow Copy Service) Writer for SQL Server. SqlServerWriter is included with SQL Server 2005. SqlServerWriter only works with instances of SQL Server 2005.