We figured this out. There was one report in the project that no longer existed in the folder location. We excluded it from the project and now it works without...

Attached is the new sample data and SSIS project I mimicked using your example. I appreciate all the help on this!

I ran into several errors, which are attached. My data actually has some decimal columns, which throws off the User::Header variable. If I was smart I would have provided other...

Sorry, I am just now getting back to this project. I have been on loan to another department for a hot project.

I do not see anywhere in the vendor...

Here are the specs directly from the instructions I received from the vendor and some sample data. I appreciate everyone's feedback on this!

The Input File must be a fixed format...

Well after submitting the SSIS file for testing I was notified that the Header and Detail must be grouped together. Ughhh... If you still have a bcp option you'd be...

Ok I have two separate data flow tasks setup and can manually fire them off to populate the flat file. How do I set this up to run the Header...

Thanks for the feedback. Do you know of a good site that shows some details on creating something similar to this with SSIS? We do not have experience with SSIS,...

We received verification that the data can be submitted with all the Header data then the Detail data, as such:

Header 06721

Header 05482

Header 04263

Detail 06721

Detail 05482

Detail 05482

Detail 04263

Etc...

Not sure if that...

I apologize for the duplicate post. We assumed the T-SQL and SSIS forums differed in forum user knowledge, so we were just trying to cover all options in figuring out...

Thanks for all the feedback. The goal is to export the result set to a fixed length flat file and submit it to a Deltek CostPoint system for import, outside...

Thank you!

Thanks for the feedback. Much appreciated!

Thanks for the feedback. Is it best practice to remove the older versions of SQL once we upgrade, or should we just leave them installed? Any feedback will be appreciated.

Thanks for the feedback. I found several utilities that will save each page as its own page, but can not find one that will name the file based of the...