Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 SQLServer closes when trying to modify a Text Import connection established by DTS Wizard

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-20 : 08:29:07
Richard writes "Can anyone tell me why SQL Server 7 closes when I try to edit a "Text File (source)" connection of a DTS local package? This only occurs with a few of my local packages, and it only occurs on the "Text File(source)" object, generally established by the wizard as "connection 1" of the package. I have created numerous packages, by assigning passwords, changing options, etc., but it doesn't resolve the problem. Essentially, I would like to change the input parameters or field lengths of the data for import, using a standard fixed length text file. Any help would be appreciated.

Regards,
Rick"
   

- Advertisement -