question

biz400 avatar image
biz400 asked

fixed length flat file

I am using SSIS to create a Fixed Length flat file for a end user who does not have ability to run SSIS job. I am looking for a way to allow this user to create this file on demand. I have a SQL query ( stored Procedure) that I am using along with SSIS. By the way, everything will work if this was done in SSRS, which essentially does not give me ability to create a FL flat file. What is the best way for me to make this happen? Thanks.
ssisssrsflat-file
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Avi1 avatar image
Avi1 answered
Simple web page with a button should work great. User just need to click on the button and your SP should be executed and dump the file at desired location. you can make this process as robust as possible. An other way is use excel, user can connect to DB from excel and execute the SP, refer below links on how to execute SP from excel https://blogs.office.com/en-us/2010/06/07/running-a-sql-stored-procedure-from-excel-no-vba/ https://www.codeproject.com/Tips/859449/Executing-A-Stored-Procedure-From-Excel-Sheet Make sure your SP dumps file at specified location.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.