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.
| Author |
Topic |
|
Tigers07
Starting Member
2 Posts |
 Posted - 2007-08-08 : 17:37:03
|
| I'm kind of a rookie and having an issue with DTS in SQL v8I'm trying to move data from a sql table to a text file (OLE DB for SQL Server -> text file destination) Transform Data Task Properties:SQL Query - want to select about 50 columns from the table defined in OLE DB source but if I select more than 30-35columns in the query it won't populate the destination - only have source on the Transformations tab. Also, when this happens if I click "define columns" it completely shuts down the console window.It works fine if I select 10-15 or so colums every thing is there and works as expected. The text file is setup as "fixed field", "ANSI", "{CR}{LF}, "First row has column names" is uncheckedThe text file is currently blank Any tips or insight would be greatly appreciated! Let me know if you need any more detail. Thanks in adavnce!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-08 : 18:17:03
|
| Do you have service pack 4 for SQL Server 2000 installed on your client machine? Service packs are not only for the server but they also contain bug fixes for the SQL tools so they should also be installed on all client machines that have the SQL tools installed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Tigers07
Starting Member
2 Posts |
Posted - 2007-08-08 : 19:14:02
|
| I don't have any SQL tools insatlled on the client PC - I remote desktop to the server and run everything from there. Windows2K3MS SQL Server Enterprise ManagerVersion 8.00.760 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-08 : 19:29:49
|
| 760 is sp3.http://www.sqlteam.com/article/sql-server-versionsIt is always recommended to get the latest service pack installed when you are having problems with the client tools. Since this is for the server, you'll probably want to test this out on a test machine first though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
DTS Issue - please help!