create a file without extension -pls help

KubirSingh 21 Reputation points
2020-09-22T12:41:40.927+00:00

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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,412 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 38,941 Reputation points
    2020-09-22T14:51:23.84+00:00

    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.

    0 comments No comments

  2. Monalv-MSFT 5,891 Reputation points
    2020-09-23T02:21:45.207+00:00

    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:
    26694-flatfileformat.png
    26636-flatfilecmgeneralpage.png
    26664-createnewfile.png
    26594-newfile.png

    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.