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

Answer recommended by moderator

Rekha 0 Reputation points Microsoft External Staff Moderator
2025-10-31T03:43:15.4066667+00:00

Hi stephane bergeron,

sorry for the delay in my response.

Below is the process to import DTSX file in visual studio. this might help you in future.

https://learn.microsoft.com/en-us/answers/questions/1501207/import-dtsx-package-into-vs-project

Thank you for confirming that you have recreated your DTSX file again. Please let us know if you need any further details.

Thanks & Regards,

Rekha Athmakuri.

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Stéphane Bergeron 0 Reputation points
    2025-10-27T15:14:42.77+00:00

    I'm not used to Visual Studio, so i don't know how to "import" my DTSX into it.

    Since it was urgent, i recreated my DTSX

    Was this answer helpful?

  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 ?

    Was this answer helpful?

  3. 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://learn.microsoft.com/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.

    Was this answer helpful?

    0 comments

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.