July 17, 2001 at 4:59 pm
I have a DTS that will not post to destination fields that have a source field with an extent. I am pulling data from a Progress database using odbc's to access the data. The fields that I am having issues with are pulling from an extent of 5, the destination field is set to a dec 20/10. I have set a message box to see if I was getting the source data and I am but it is not posting to the destination field. I get all the other attributes of the data except the fields that have an extent set to them
DTSDestination("meatcost_1") = DTSSource("meatcost__1")
DTSDestination("meatcost_2") = DTSSource("meatcost__2")
DTSDestination("meatcost_3") = DTSSource("meatcost__3")
DTSDestination("meatcost_4") = DTSSource("meatcost__4")
DTSDestination("meatcost_5") = DTSSource("meatcost__5")
any ideas??
Steve Johnson
Steve Johnson
July 17, 2001 at 6:04 pm
What is an extent? Apologies, but I am not familiar with Postgress.
Can you transfer from Postgress to varchar() or to a text file?
Steve Jones
July 17, 2001 at 7:47 pm
Im curious too - why do you have the repeating fields (meat1, meat2, etc)? If you're taking the time to move it to SQL, why not normalize while you do it?
Andy
July 18, 2001 at 11:10 am
[This data has been summurized for a data warehouse, I didn't design or create it I am just tasked with moving it from one envroment to another]
Im curious too - why do you have the repeating fields (meat1, meat2, etc)? If you're taking the time to move it to SQL, why not normalize while you do it?
Andy
[/quote]
Steve Johnson
Steve Johnson
July 18, 2001 at 12:49 pm
Gotcha. So what is the extent you refer to?
July 18, 2001 at 2:07 pm
In Progress you can create a field ("meatcost") then assign an extent of (1-12) to the field, you might know this as an array. In this case we have a field called meatcost, it was assigned an extent of 5. So meatcost[1] would = standard cost, meatcost[2] = ncad costs and meatcost[3] = current cost, we are not using meatcost[4] or [5].
Steve Johnson
Steve Johnson
July 18, 2001 at 3:55 pm
I think that based on this, you need separate fields in SQL Server for each extent. Then this
DTSSource("meatcost__1")
Needs to return the correct value.
Will this work to a text or xls file?
Steve Jones
July 18, 2001 at 4:19 pm
Yes it does work to a text file and I have started to lean that way..... reluctantly because I feel that if the data will show up in a msgbox then you should be able to post it to the destination field....
Steve Johnson
Steve Johnson
July 18, 2001 at 11:04 pm
So you're issuing the following in your ActiveX script and everything displays properly:
MsgBox DTSSource("meatcost__1")
Is that the case?
K. Brian Kelley
K. Brian Kelley
@kbriankelley
July 19, 2001 at 10:56 am
That is correct
Steve Johnson
Steve Johnson
July 19, 2001 at 11:17 am
Did you try:
Dim MeatCost_1
Dim MeatCost_2
Dim MeatCost_3
Dim MeatCost_4
Dim MeatCost_5
MeatCost_1 = DTSSource("meatcost__1")
MeatCost_2 = DTSSource("meatcost__2")
MeatCost_3 = DTSSource("meatcost__3")
MeatCost_4 = DTSSource("meatcost__4")
MeatCost_5 = DTSSource("meatcost__5")
DTSDestination("meatcost_1") = MeatCost_1
DTSDestination("meatcost_2") = MeatCost_2
DTSDestination("meatcost_3") = MeatCost_3
DTSDestination("meatcost_4") = MeatCost_4
DTSDestination("meatcost_5") = MeatCost_5
You shouldn't have to do that, but maybe that work around will fix things?
K. Brian Kelley
K. Brian Kelley
@kbriankelley
July 19, 2001 at 11:32 am
Good Idea.... though I have already tried this...:)
Steve Johnson
Steve Johnson
July 19, 2001 at 11:37 am
Is it returning an error or just not populating the field?
K. Brian Kelley
K. Brian Kelley
@kbriankelley
July 19, 2001 at 11:56 am
No error, and no data is posting to the destination field
Steve Johnson
Steve Johnson
July 19, 2001 at 8:38 pm
Can you verify that these are being correctly populated? Could some be null? Some kind of special char that delimits the array/extent?
MeatCost_1 = DTSSource("meatcost__1")
MeatCost_2 = DTSSource("meatcost__2")
MeatCost_3 = DTSSource("meatcost__3")
MeatCost_4 = DTSSource("meatcost__4")
MeatCost_5 = DTSSource("meatcost__5")
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply