question

Mrs_Fatherjack avatar image
Mrs_Fatherjack asked

SSIS and DBase files

This again links to previous questions I've asked, however. I am writing an SSIS package to manipulate data, some of it starts in and must end up in DBF files. I decided the best way to manipulate the data was to import it to SQL, do what I need to do and then export it back to the DBF Files. I've now done everything I need and need to save it back to DBF. I've tried various methods and found the easiest way is to create a package using the export wizard to move the data and then call the execute pacakge from within my SSIS package. The export wizard works on it's own fine but is erroring when called from within the SSIS package. ![alt text][1] THis is the set up of the execution package task. The error message I'm getting is: > Error: Error 0xC0014062. Failed to load the package "Export_actgchg.dtsx" from SQL Server "C:\\LEAN_EOM\\vamp". Make sure the package exist on the SQL Server and you have the correct credential to access it. Any ideas, gratefully received. [1]: /upfiles/SD10.jpg
ssisexportdbase
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Nothing really related to your post, but why does Ask.SSC drop backslashes? They can be an import part of the post/question, and can make you look like you typed your code, etc wrong.
0 Likes 0 ·
@meltondba : backslash is used as the escape character in markdown, more info here to make one appear use 2 : \\\ (obviously I typed 3 here :))
0 Likes 0 ·
Many thanks for all your help with this, I have found the issue was because I set the Location to SQL Server and it should have been File system.
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Do you mean that you can run it as a stand-alone package within the SSIS development environment, but not as a scheduled task? If so, then check the security context under which the scheduled task runs - does that have access to the appropriate directory?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

When I created it from within SSMS and then executed it it worked OK. I think the scheduled task runs under my user details which I would have thought would be the same - maybe I'm just being thick. Can you please advise where I need to look? Many thanks.
0 Likes 0 ·
Two things to look at: Run services.msc. Check the login details for the SQL Agent service. Using SSMS, check the owner / "run as" details within the job definition itself.
0 Likes 0 ·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
As @ThomasRushton stated, the scheduled task doesn't have appropriate rights on file system. Run the SQL Server Configuration Manager and check under which account is running the SQL Server Agent Service. All the packages executed from within a Job (scheduled task) are executed under this account. This account needs to have appropriate right on the filesystem to access the dtsx package. Also the account uder which the Agent Service is running needs to have apropriate right on the destination directory, where you will output your dbf files, otherwise the data flow task will fail. If you are executing it from within SSMS, then it's running under account, under which the SSMS is running.. In most cases your account under which you are logged in. So you need to setup apropriate right on the file system for the Agent Service account.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dosberg avatar image
dosberg answered
Got the same error the other day. I was trying to edit the Sql agent job from my local ssms and it tried to find the package on my local drive instead of the server. RDP'd into the server and made the change there and it worked just fine. Hope that helps.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jeffrey39 avatar image
jeffrey39 answered
You may extract dbf file due to [ http://www.dbf.repairtoolbox.com][1] tool also can open/read/export-import/scan/repair dbf files [1]: http://www.dbf.repairtoolbox.com
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.