473,322 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

DTS dilemma

Using SQL2000, I cannot get a DTS working based from VB Transformation DTS
below.
Data originates from MS Access database and gets imported onto SQL. I have
two versions that kept giving me same error message. Help!
1ST VERSION:

Select Case DTSSource("STATUS")
Case 1
DTSDestination("STATUS") = 3
Case 2
DTSDestination("STATUS") = 4
Case 5
DTSDestination("STATUS") = 1
Case 6
DTSDestination("STATUS") = 2
Case 9
DTSDestination("STATUS") = 99
Case 3
If DTSSource("DEFINITION2") = "1" Then <=== Line 17, source of error
DTSDestination("STATUS") = 6
Elseif DTSSource("DEFINITION2") = "2" Then
DTSDestination("STATUS") = 5
End If
Case 4
If DTSSource("DEFINITION2") = "1" Then
DTSDestination("STATUS") = 8
Elseif DTSSource("DEFINITION2") = "2" Then
DTSDestination("STATUS") = 7
End If
End Select
2ND VERSION:

If DTSSource("STATUS") = "1" Then
DTSDestination("STATUS") = 3
Elseif DTSSource("STATUS") = "2" Then
DTSDestination("STATUS") = 4
Elseif DTSSource("STATUS") = "5" Then
DTSDestination("STATUS") = 1
Elseif DTSSource("STATUS") = "6" Then
DTSDestination("STATUS") = 2
Elseif DTSSource("STATUS") = "9" Then
DTSDestination("STATUS") = 99
Elseif DTSSource("STATUS") = "3" And DTSSource("DEFINITION2") = "1" Then
<=== Line 17, source of error
DTSDestination("STATUS") = 6
Elseif DTSSource("STATUS") = "3" And DTSSource("DEFINITION2") = "2" Then
DTSDestination("STATUS") = 5
Elseif DTSSource("STATUS") = "4" And DTSSource("DEFINITION2") = "1" Then
DTSDestination("STATUS") = 8
Elseif DTSSource("STATUS") = "4" And DTSSource("DEFINITION2") = "2" Then
DTSDestination("STATUS") = 7
End If
ERROR MESSAGE:
The number of failing rows exceeds the maximum specified.
Error Code: 0
Error Source: Microsoft VBScript runtime error
Error Description: Invalid Procedure call or argument: 'DTSSource'
Error on Line 17

Jul 20 '05 #1
0 2466

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Pete | last post by:
I'm developing an open source CMS, but have come across a problem. The system dynamically creates .php files for the front-end of the site, meaning they're owned by user 'nobody'. However, for...
1
by: Miha | last post by:
hi to everyone... could someone mail me a sample source code of the spatial prisoner's dilemma game...application code,not applet...thanx in advance mihael.sedmak@fer.hr
12
by: Thomas Matthews | last post by:
Hi, According to Robert Martin's Dependency Inversion Principle, http://www.objectmentor.com/resources/articles/dip.pdf, when there is a need to test the type of an object, the code inside the...
0
by: Colin Basterfield | last post by:
Hi all, Not sure if this is the most appropriate place for this so apologies if inappropriate... I have come back to a framework I built some time ago to see where some refactoring can take...
5
by: c#freeskier89 | last post by:
Can someone please give me some information on sending data through a USB port. What I am trying to do is use the USB port (I get how to do it on a COM port). I am using VC# 2005. I have searched...
0
by: Chris | last post by:
Hi, I have a dilemma. I have a web form that, when submitted, does a window.open js function to submit the form data to a new aspx page which then shows a report. I wanted to make sure that...
1
by: Bishop | last post by:
I have a page that generates a grid of controls; at the end of each row is an update button that is dynamically created with an associated click event. The grid changes based on the date selected...
9
by: John | last post by:
Greetings. I apologize for posting this if it is in the wrong group. The boss last week dropped vb.net on my desk and wants to create a web app and a corresponding desktop app. And I'm a newbie to...
16
by: hzmonte | last post by:
Correct me if I am wrong, declaring formal parameters of functions as const, if they should not be/is not changed, has 2 benefits; 1. It tells the program that calls this function that the...
7
by: Kamilche | last post by:
''' I'm in the middle of a refactoring dilemma. I have several singletons that I'm turning into modules, for ease of access. The usual method is noted as 'Module 1' below. The new method is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.