asked on
sql server 2000 ssis flatfile destination problem
I have a package that populates a table via several flatfile sources. I then need to run a queries against this table to generate multiple flatfiles. The table has a "recordType" column and each flatfile destination is simply all records with recordType = 0, or recordType = 1, etc...
When I setup my flatfile destination and choose a file destination, I then click on the OLEDB icon and then click on the flatfile icon, right click, click on Transform Data Task. I write my query as the source
select * from AYP_Container WHERE recordType = 0
I hit preview and see my records. I click on the Destination tab and a window pops up, I click on Populate from Source, and then Execute.. However, my Destination tab is blank where it should show the destination columns. If I click on "Define Columns", the Enterprise Manager crashes every time.
Even if I open the destination text file and manually put a CSV line of column headers in the file, I get the same result. The destination columns wont appear in the transform data task on either the Destination tab OR the Transformations tab and everytime I click on Define Columns, enterprise manager crashes and closes.
I'm getting very upset that I cant seem to simply export a table to a flat file. I even created a new package that did only that, oledb connection, flatfile destination, the source is just a single table (not a query), and I get the same thing, no destination columns and a crash.
I'd like to keep the solution all in the same package if at all possible.
When I setup my flatfile destination and choose a file destination, I then click on the OLEDB icon and then click on the flatfile icon, right click, click on Transform Data Task. I write my query as the source
select * from AYP_Container WHERE recordType = 0
I hit preview and see my records. I click on the Destination tab and a window pops up, I click on Populate from Source, and then Execute.. However, my Destination tab is blank where it should show the destination columns. If I click on "Define Columns", the Enterprise Manager crashes every time.
Even if I open the destination text file and manually put a CSV line of column headers in the file, I get the same result. The destination columns wont appear in the transform data task on either the Destination tab OR the Transformations tab and everytime I click on Define Columns, enterprise manager crashes and closes.
I'm getting very upset that I cant seem to simply export a table to a flat file. I even created a new package that did only that, oledb connection, flatfile destination, the source is just a single table (not a query), and I get the same thing, no destination columns and a crash.
I'd like to keep the solution all in the same package if at all possible.
table schema
CREATE TABLE [dbo].[AYP_Container](
[districtInstruction] [char](3) NULL,
[districtEnrollment] [char](2) NULL,
[schoolNumberEnrollment] [char](4) NULL,
[studentNumber] [char](10) NULL,
[surveyPeriodCode] [int] NULL,
[schlYear] [int] NULL,
[studentNumberAlias] [char](10) NULL,
[studentName_Last] [char](17) NULL,
[studentName_First] [char](12) NULL,
[studentName_Middle] [char](10) NULL,
[studentName_Appendage] [char](3) NULL,
[gender] [char](1) NULL,
[race] [char](1) NULL,
[ell] [char](2) NULL,
[grade] [char](2) NULL,
[birthdate] [char](8) NULL,
[qualifyingArrivalDate] [char](8) NULL,
[lunchStatus] [char](1) NULL,
[homelessStudent] [char](1) NULL,
[additionalSchoolYear] [char](1) NULL,
[primaryExceptionality] [char](1) NULL,
[otherExceptionality] [char](9) NULL,
[alternateAssessmentAdministered] [char](1) NULL,
[priorSchoolDistrict] [char](2) NULL,
[withdrawalCode] [char](3) NULL,
[withdrawalDate] [char](8) NULL,
[deletionReason] [char](1) NULL,
[priorSchoolStatus] [char](1) NULL,
[schoolMatch] [char](1) NULL,
[districtMatch] [char](1) NULL,
[multiplePSSMatch] [char](1) NULL,
[multipleDEMOMatch] [char](1) NULL,
[ellEntryDate] [char](8) NULL,
[ellExitDate] [char](8) NULL,
[districtZonedSchool] [char](2) NULL,
[schlZonedSchool] [char](4) NULL,
[entryDate] [char](8) NULL,
[section504Eligible] [char](1) NULL,
[dropoutPreventionPrograms] [char](1) NULL,
[recordType] [int] NULL
) ON [PRIMARY]
Microsoft SQL Server
Last Comment
MMDeveloper