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
example for sqlsrvrwrite function
Moderators: chulett, rschirm, roy
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers