Share via

how to modify a DTSX file ?

Stéphane Bergeron 0 Reputation points
2025-10-21T09:35:20.2233333+00:00

Good morning,

Weeks ago, i created a DTSX file to import data from a flat text file into a SQL table.

I'm realizing that i stupidly forgot to check the "empty table before import" box.

Is there a way to modify that parameter without recreating the whole DTSX ?

SQL Server Integration Services
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rekha 0 Reputation points Microsoft External Staff Moderator
    2025-10-21T10:38:01.0266667+00:00

    Hi Stephane Bergeron,

    Thank you for reaching out to us.

    You can edit the DTSX file using Visual Studio. The issue linked below provides a detailed explanation on how to open a DTSX file in Visual Studio.

    https://free.blessedness.top/en-us/answers/questions/1096955/open-a-dtsx-file-in-design-view

    If you need any more help, please let us know. We are happy to assist.

    Thanks & Regards,

    Rekha Athmakuri.

    0 comments
  2. Stéphane Bergeron 0 Reputation points
    2025-10-22T12:07:20.3766667+00:00

    Is there a way to do this without Visual Studio ?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.