He means do something like this:

create the view via TSQL, for example:

CREATE VIEW MyView

AS

SELECT

[Student Number],

IRN,

Name,

Gender,

Address,

city,

state,

zip,

phone,

birthdate,

Grade,

Lastname4 + first AS 'Homeroom',

Teacher

FROM (SELECT

DISTINCT

LEFT(ISNULL(s.studentNumber, '') + SPACE(9), 9) AS 'Student Number',

CASE LEFT (ISNULL (sc.number, '') + SPACE (6), 6)

WHEN 5101

THEN '029876'

WHEN 5102

THEN '145086'

WHEN 5111

THEN '112581'

WHEN 5112

THEN '145078'

WHEN 5121

THEN '138966'

WHEN 5122

THEN '138958'

WHEN 5123

THEN '011369'

WHEN 5131

THEN '086579'

WHEN 5135

THEN '142638'

WHEN 5132

THEN '029868'

WHEN 5133

THEN '065433'

WHEN 5137

THEN '011368'

WHEN 5136

THEN '011370'

WHEN 5134

THEN '123307'

END AS 'IRN',

LEFT(ISNULL(s.lastName + ', ' + s.firstName, '') + SPACE(36), 36) AS 'Name',

LEFT(ISNULL(s.gender, '') + SPACE(1), 1) AS 'Gender',

LEFT(ISNULL(a.number + ' ' + a.street + ' ' + a.tag, '') + SPACE(51), 51) AS 'Address',

LEFT(ISNULL(a.city, '') + SPACE(18), 18) AS 'City',

LEFT(ISNULL(a.state, '') + SPACE(4), 4) AS 'State',

LEFT(ISNULL(a.zip, '') + SPACE(9), 9) AS 'Zip',

LEFT(ISNULL(hh.phone, '') + SPACE(14), 14) AS 'Phone',

CONVERT(VARCHAR, s.birthdate, 111) AS 'birthDate',

LEFT(ISNULL(s.grade, '') + SPACE(6), 6) AS 'Grade',

LEFT(ISNULL (se.teacherdisplay, '') + SPACE (4), 4) AS Lastname4,

LEFT(LTRIM(STUFF(se.teacherdisplay, 1, CHARINDEX(',', se.teacherdisplay), '')), 1)AS 'First',

LEFT(ISNULL(se.teacherdisplay, '') + SPACE(26), 26) AS 'Teacher',

ROW_NUMBER() OVER(PARTITION BY s.studentnumber ORDER BY s.studentnumber) AS RN

FROM pickerington.dbo.student s

INNER JOIN pickerington.dbo.school sc

ON sc.schoolID = s.schoolID

LEFT JOIN pickerington.dbo.HouseholdMember hm

ON hm.personID = s.personID

LEFT JOIN pickerington.dbo.Household hh

ON hh.householdID = hm.householdID

LEFT JOIN pickerington.dbo.HouseholdLocation hl

ON hl.householdID = hh.householdID

LEFT JOIN pickerington.dbo.Address a

ON a.addressID = hl.addressID

JOIN pickerington.dbo.Roster r

ON r.personID = s.personID

JOIN pickerington.dbo.Section se

ON se.sectionID = r.sectionID

JOIN pickerington.dbo.SectionPlacement sp

ON sp.sectionID = se.sectionID

JOIN pickerington.dbo.Period p

ON p.periodID = sp.periodID

JOIN pickerington.dbo.Course c

ON c.courseID = se.courseID

JOIN pickerington.dbo.Calendar ca

ON ca.calendarID = c.calendarID

AND ca.calendarID = s.calendarID

AND sc.schoolID = ca.schoolID

JOIN pickerington.dbo.SchoolYear sy

ON sy.endYear = ca.endYear

WHERE s.calendarID IN ( 8, 12, 16, 20,

24, 28, 32, 36,

40, 44, 48, 52,

56, 60 )

AND s.startYear = '2012'

AND s.endDate IS NULL

AND (( ( sc.number IN ( 5101, 5102, 5111, 5112 )

AND p.seq = 2 )

OR ( sc.number IN ( 5121, 5122, 5123, 5131,

5132, 5133, 5134, 5135,

5136, 5137 )

AND c.homeroom = '1'

OR p.seq = 1 ) )))s

WHERE rn = 1

then your query will not hit the size limit of a command in the cmd window, because your bcp command changes to this:

bcp "SELECT * FROM DatabaseName.dbo.MyView" queryout "C:\User\jpost\Info\Student_Info.txt" -S pickeringtoncmb -c -T