Category : ssis

Hi I have a SSIS Package which has a simple dataflow with Excel to Excel data transfer.I am using Microsoft.ACE.OLEDB 12.0 driver for connection.Now in my development machine it is running fine through packages.BUt when I deploy and ran it via SQl agent job it is giving me the error ‘The step did not generate ..

Read more

My SSIS package creates folder on the C:, copies files from network path into this folder and creates new files into this folder. Package is deployed to the sql server ssis catalog. To configure the package to run via sql agent job, I have connected to the SQL sever as sysadmin and: Under security, configured ..

Read more

My SSIS package creates folder on the C:, copies files from network path into this folder and creates new files into this folder. To deploy this, I have connected to the SQL sever as sysadmin. Under security, configured a credential with username as domainnameuser1 and the correct password. Under SQL server agentproxies I have then ..

Read more

I am getting this error when attempting to execute a DTSX package from the command line when logged in as a service account inside a domain. Code: 0xC0011002 Source: {6DB934F3-5312-4C7C-9E59-D8CF30910966} Description: Failed to open package some_serversome_export_foldersome_export_ssis_package.dtsx Access denied due to error 0x80070005. This occurs when loading a package and the file cannot be opened or ..

Read more