[dba-SQLServer] Output wizard choked

Just google it :)


I've found articles on www.sqlteam.com quite helpful. A subscription to
SQLMag.com has been quite helfpul as well. I also have the Microsoft SQL
Server 2000 Bible from Wiley Press.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, May 16, 2007 1:59 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Output wizard choked

I gotta get a book for this stuff.

John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Wednesday, May 16, 2007 4:49 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Output wizard choked

SUBSTRING('abcdef', 2, 3) returns bcd

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, May 16, 2007 1:18 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Output wizard choked

I tried to set up an export using the export wizard.  It choked because the
data in the address1 field was larger than the allowed data field width that
I entered.  The output file is a fixed width file speced by the customer so
what there is is what there is.  I saw no place to edit the transform or
tell it to go ahead and trim the data.  I did save the transform info in a
DTSX file, though the last time I did that it didn't end up very useful.

What is the SQL Server syntax for returning the first N characters?

Any suggestions.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.7.1/805 - Release Date: 5/15/2007
10:47 AM