question

LakshmSK-3896 avatar image
0 Votes"
LakshmSK-3896 asked ZoeHui-MSFT edited

Part of DTSX package is running fine but failing at last step saying 0xC000F427

When running sql server version 2017 compiled dtsx package on the machine is running fine but when running on scheduling job server in the path of \Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\DTExec.exe failing saying
Error: 2021-06-03 19:06:02.94
Code: 0xC000F427
Source: FSYS Creating Folder With Current Date
Description: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition of Integration Services or higher.
End Error.

the server already has 2017 integration services. The package is doing a whole lot of things but it's failing at the last step only.

sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LakshmSK-3896,

Few questions:

  • Are you running your package in the SSIS Catalog?

  • What the failing step is doing? Please share your package Control Flow screen shot.

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @LakshmSK-3896,

With the error message it seems that you need to install SSIS.

However you said that the server already has 2017 integration services.

Please have a double check by running “services.msc” in DOS windows.

Also the issue is a little same as here.

You may take a refer to see if you developed your code on a Developer edition of SQL Server and deployed to a SQL Server Standard edition.

Regards,

Zoe


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.
Hot issues October

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.