When you try to compile a Microsoft Visual Basic file that was created when you saved a
Data Transformation Services (DTS) package, the Visual Basic compiler raises a syntax error. The error is detected in a line where a literal is assigned
to a textual property of a DTS object.
If the literal that is assigned to a textual property is larger than
263 characters, and there are no line breaks in the middle of the string, an
error in the chunking/concatenation routine introduces syntax errors in
the Visual Basic code that is generated.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211
(http://support.microsoft.com/kb/290211/
)
How to obtain the latest SQL Server 2000 service pack
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Microsoft SQL Server 2000 Service Pack 4.
Right-click Local Packages, and then click New Package.
In the DTS Package Designer window, on the Connection menu, click Microsoft OLE DB Provider for SQL Server.
In the Connection Properties dialog box, set the connection properties to appropriate values, and
then click OK.
On the Task menu, click Execute SQL Task.
In the SQL statement box, enter the following statement, and then click OK:
CREATE TABLE [dbo].[MyFirstTestTable] ([FirstColumn] [int] NOT NULL, [SecondColumnOne] [int] NOT NULL, [ThirdColumn] [int] NOT NULL, [FourthColumn] [int] NOT NULL, [FifthColumn] [int] NOT NULL, [SixthColumn] [int] NOT NULL, [SeventhColumn] [int] NOT NULL) ON [PRIMARY]
Note Make sure that you remove all line breaks from the previous statement.
On the Package menu, click Save As.
In the Save DTS Package dialog box, in the Location box, click Visual Basic File.
Select a location, enter an appropriate file name in the File name box, and then click OK.
In Visual Basic or in another text editor, open the generated .bas file.
The following lines are located several lines
before the end of the file:
oCustomTask1.SQLStatement = "CREATE TABLE [dbo].[MyFirstTestTable] ([FirstColumn] [int] NOT NULL, [SecondColumnOne] [int] NOT NULL, [ThirdColumn] [int] NOT NULL, [FourthColumn] [int] NOT NULL, [FifthColumn] [int] NOT NULL, [SixthColumn] [int] NOT NULL, [SeventhColumn] [int] NOT NULL) ON [PRIM"
oCustomTask1.SQLStatement = "CREATE TABLE [dbo].[MyFirstTestTable] ([FirstColumn] [int] NOT NULL, [SecondColumnOne] [int] NOT NULL, [ThirdColumn] [int] NOT NULL, [FourthColumn] [int] NOT NULL, [FifthColumn] [int] NOT NULL, [SixthColumn] [int] NOT NULL, [SeventhColumn] [int] NOT NULL) ON [PRIM"oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "ARY]"
The second line introduces a syntax error for the Visual Basic compiler.
Back to the top
