Can you use osql in DTS?
me_at_privacy.net
Date: 05/12/04
- Next message: JC: "How to fire off job from c#"
- Previous message: Rohan Hattangdi: "Re: Help me convince the dev manager. Please."
- Next in thread: Tom Moreau: "Re: Can you use osql in DTS?"
- Reply: Tom Moreau: "Re: Can you use osql in DTS?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 May 2004 16:24:26 -0400
I had put out a question earlier today that may need to be re-asked.
Can the osql be used in DTS?
I have to create a bunch of files, that will need the same date & time stamp
glommed onto the first part of the row.
I do this by putting the following code in the SQL I have in the
transformation:
DECLARE @curDate As DateTime
DECLARE @curTime As DateTime
SET @curDate = GetDate()
SET @curTime = GetDate()
declare @charDate as char(8)
declare @charTime as char(8)
set @chardate = convert(char(8),@curDate,112)
set @charTime = STUFF(STUFF(convert(char(8),@curTime,114),3,1,''),5,1,'')
Once that's in there, I would pass in the two parameters @chardate &
@chartime into a stored procedure that I would call. I want that stored
procedure to then use those 2 parameters and create a header record.
Then, I'd want to call another stored procedure and have it output to a
different text file, for the next set of records, while keeping the same
@chardate & @chartime I had above in the first stored procedure to be
glommed onto the records in the 2nd table. And so on.
I need to have the same @chardate & @chartime on each of the records in
order to identify it as a "batch" within the external system.
I know that osql can use a /o command to put the output to a particular
file, but not sure if it can be done within DTS.
Ideally, I'd like to put my code for the select statement into a stored
procedure and then call it, but not sure if oSql is the way to go or not.
Any advice appreciated.
- Next message: JC: "How to fire off job from c#"
- Previous message: Rohan Hattangdi: "Re: Help me convince the dev manager. Please."
- Next in thread: Tom Moreau: "Re: Can you use osql in DTS?"
- Reply: Tom Moreau: "Re: Can you use osql in DTS?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
