CODEWITHSUNDEEP
sql-server-2008ssis
Dilanka
Dilanka

Reputation: 39

How to run a SSIS Package which has a file based source and a target

I have a dtsx file which i saved on my desktop.

It grabs a particular file(Source file (CSV)) and concatenate with the other file(Target file (CSV) as an appending manner . How can I run this DTSX? I just want this to be run on a regular basis without using sqlserver as it has nothing to do with the server.

I created this using a import and export data wizard in sql server 2008.

Upvotes: 2

Views: 3265

Answers (1)

Ciarán
Ciarán

Reputation: 3057

You can run SSIS Packages standalone via DTEXEC or by double clicking on the package to run the "Execute Package Utility" (DTEXECUI).

These would need to be installed which you do so by installing SSIS and the SQL/Server workstation tools.

You can do this via the Business Intelligence Development Studio (BIDS) as well, though this would give the workstation the ability to modify the package as well.

Upvotes: 2

Related Questions