473,324 Members | 2,370 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,324 software developers and data experts.

SQL 2000 DTS tool - 256 char limit?

Jim
I'm using the DTS tool (generally called "Import and Export Data", two cogs)
to export a table to a text file. However, it seems to be truncating the
char(1024), in that it's only outputting the first 256 chars. Is this a
limit of the tool, or am I just doing something wrong? It's early and the
coffee hasn't kicked in yet...

I'm not altering any settings/transformations etc., it should be just a text
version of the table, warts and all.

Interestingly, Queary Analyser does the same thing in that it only returns
the first 256chars. I can understand that in QA, but in DTS it just seems
odd.

Jim
--
http://www.ursaMinorBeta.co.uk http://twitter.com/GreyAreaUK

"Sometimes when I talk to a Windows person about using a Mac,
I feel like I'm explaining Van Halen to a horse." Merlin Mann
Aug 1 '08 #1
1 2525
Jim
On 2008-08-01, Jim <ji*@magrathea.plus.comwrote:
I'm using the DTS tool (generally called "Import and Export Data", two cogs)
to export a table to a text file. However, it seems to be truncating the
char(1024), in that it's only outputting the first 256 chars. Is this a
limit of the tool, or am I just doing something wrong? It's early and the
coffee hasn't kicked in yet...

I'm not altering any settings/transformations etc., it should be just a text
version of the table, warts and all.

Interestingly, Queary Analyser does the same thing in that it only returns
the first 256chars. I can understand that in QA, but in DTS it just seems
odd.
Okay, sorry, should have Googled first - short answer is "yes, it's a limit
of DTS". Solution is to use BCP instead.

Now I just need to get my head around BCP. Wish me luck.

Jim
--
http://www.ursaMinorBeta.co.uk http://twitter.com/GreyAreaUK

"Sometimes when I talk to a Windows person about using a Mac,
I feel like I'm explaining Van Halen to a horse." Merlin Mann
Aug 1 '08 #2

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

Similar topics

2
by: Brian | last post by:
SQL Server 2000 SP3 on a Dell dual 2.4GHz Xeon box 3GB RAM Windows 2K SP4. Two aplication dbs, each less than 2GB in size. Had a problem where we would run Solomon queries and what not against...
3
by: Michael | last post by:
I am using MS Access 2000 on an Windows XP machine and am trying to use the Upsizing Tool in Access 2000 to upsize an Access 2000 database to use with Microsoft SQL Server 7.0. My MS Access...
4
by: Vikrant | last post by:
Hey friends Can someone please suggest that how many recordset can be opened simultaneously for a MS-Access 2000 Database.Does that make any difference if we use ODBC or some other way of...
4
by: imani_technology_spam | last post by:
Is there a limit to how much text you can concatenate (other than data type limits, of course)? For example, if you write: SELECT 'This is some text from: ' + Convert(char(15), SomeFieldName01)...
3
by: Dan Sikorsky | last post by:
Can I use SQLServer 2000 with ASP.NET 2.0 instead of SQLServer 2005, and use the .Net 2.0 Membership functionality? I've setup my Login page, controls, etc., and now it's time to use the Web...
2
by: Rex | last post by:
Hi I have a table called "Member" as given below.. familyID memberID firstName -------- -------- -------------------- 0 7 Stuart 0 5 Kasey 0 1 Sally...
17
by: mdh | last post by:
In trying to understand the issue, I wrote this; #include <stdio.h> void f_output(char arg1, int limit); int main () { f(); return 0; }
1
by: Howard Canaway | last post by:
Hello, I help maintain an Access 2000 front end for a rapidly growing business(our back end is Postgresql). As we grow we have concerns over the long term viability of Access 2000 to keep us going...
12
by: kevin.eugene08 | last post by:
Hello all, Forgive the somewhat simple question I am sure this will be, but I am having some problem understanding what: char **argv looks like. For instance, i know through trial and error...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
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: 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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.