DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
navya123
Participant



Joined: 29 Dec 2010
Posts: 4

Points: 48

Post Posted: Mon Jan 03, 2011 6:39 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
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
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42520
Location: Denver, CO
Points: 218805

Post Posted: Mon Jan 03, 2011 7:00 am Reply with quote    Back to top    

Welcome. Can you please edit your first post and let us know your Release, Job Type and OS? Thanks.

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
navya123
Participant



Joined: 29 Dec 2010
Posts: 4

Points: 48

Post Posted: Mon Jan 10, 2011 4:30 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42520
Location: Denver, CO
Points: 218805

Post Posted: Mon Jan 10, 2011 8:00 am Reply with quote    Back to top    

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.

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42520
Location: Denver, CO
Points: 218805

Post Posted: Mon Jan 10, 2011 8:09 am Reply with quote    Back to top    

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.

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours