Forgot to mention. I'm running mine in an SSIS package so just created a Flat File destination to send the file.

Here is how I setup my SQL Script to pull the data into an XML File.

SELECT(select s.StudentNumber As DisplayID, s.PersonID AS ExternalAccountID, sc.number AS SchoolID,s.FirstName, s.LastName, s.Gender,

CONVERT(varchar,s.birthdate,101) AS Birthdate,...

In the heading area when setting up the destination file I had to add in <?xml version="1.0" encoding="utf-8"?>

That gave me what the vendor was needing in the file.

I had created the SSIS package to pull just the student data.

What the vendor was wanting was the XML information <?xml version="1.0" encoding="utf-8"?> added to the first row of the...

Thanks I'll try that and see what happens.

Thanks. I've tried that to make sure my numbers are correct and I can get the numbers to pull correctly even filtering down to one section and get my numbers...

I've attached a document with the table structures for the tables being used.

What I am needing is that the Total Student count remain the same for that teacher regardless of...

Here is the actual script with the actual table names. Below the script is the result based on what was entered for the Score Variable.

DECLARE @School int

DECLARE @Term int

DECLARE @Score...

Thanks Tim,

Unfortunately this is not an FTP server.I was hoping it was, so I could have used the FTP task.

Thanks

Wayne

Thanks, I'll try that since the other types I've tried aren't working

I've been working on this SIS package still and have to completely rebuild the package 3 times now from the ground up.

In the Configuration File I have the Connection String,...

Apoligize for taking awhile to get back to you on this.

I switched the Package to look at XML and now when I open the package it starts through it's validation...

That helped quite a bit. I went into the Package on the original machine that it was built on and turned the Encryption off and at least don't have the...

Actually just because of this I've got a 2005 version and a 2008 version.

When I started to put it on my Server 2008 box I copied it over to VS...

The main SIS package that I am having a problem with is one that pulls information from a Progress database and dumps the data into SQL. It uses a Progress...