create a file without extension -pls help

Question

Hi,
I have a little confusing requirement. From a Source database table, I need to extract some data and create a file out of it. Sofar I have created a csv, text or excel files. But now, I need to create a fixed width file (with no extension).
For development,I am creating a text file. But for QA and PROD, I need to create a file without any extension. Can someone please help me on this?

Answer 1

And with which part do you have an issue?
In a SSIS package you can create a flat file connection with any extension, also with an empty one.

Answer 2

Hi @KubirSingh ,

1.We can choose Flat File Format as Fixed width when configuring the flat file connection manager.
2.We can type file name without extension and choose All files(.) when clicking Browse... in the connection manager.

Please refer to the following pictures:

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.