DTS import/export - error when saving package as a visual basic file 
Author Message
 DTS import/export - error when saving package as a visual basic file

Hi All, I think, I found an error in DTS import/export wizards. In MS SQL server 2000 (developer edition)
SP 3
I am able to get invalid visual basic file generated by this wizard. All you need to do it is to have tables
with quite a lot of columns - you can use this script to generate two such tables
(one source table, one destination table):






begin


end




Now right click the TEST_TABLE_SRC in the Enterprise Manager select the All Tasks->Export Data
option, click next,
 select the same database as a target database, click next, leave the option Copy table(s)... active,
click next select the check box by the TEST_TABLE_SRC table, select the TEST_TABLE_DEST as a
destination table,
click next, uncheck run immediately, check Save DTS package, choose Visual Basic File, finish the
export.
Now open the newly created file and find "oCustomTask1.SourceSQLStatement" statement - there is
a
bug in splitting this SourceSQLStatement string into more than one line when it is too long,
there is something like

statement="select ..."
statement="select ..."statement=statement&"...."
statement="select ..."statement=statement&"...."statement=statement&"...."



Mon, 03 Jul 2006 16:28:57 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. DTS Package saved as Visual Basic file

2. DTS error migrating dts saved to file packages.

3. DTS error message when executing a package from Visual Basic

4. DTS Package Save takes too much time when saved and Meta Data Services Package

5. Importing text files into SQL Server 2000 Database using DTS Import/Export Wizard

6. Automatically export DTS Packages to .dts files

7. Import a DTS Package from a DTS file

8. Visual Basic, DTS, and that DTS Help file

9. how can I import and export DTS package and SQL Server Agent between SQL Server Groups

10. Problem exporting/importing acutal DTS packages

11. Importing/exporting DTS packages

12. Importing/Exporting DTS packages


 
Powered by phpBB® Forum Software