Integration with SSIS?

[DanielHLei]

I used the DataSync interface to create a .sij file.

I used the generated command and put it in a .bat file.

If I execute the .bat file, the .sij file updates the webpage.

If I put the path to the .bat file in an Execute Process Task and run the SSIS package in dev mode, it also updates the website.

However, when I go to run the SSIS package using a SQL Server Agent job, I get a Code: 0xC0029151 error. We have checked the job. All of the credentials that are running the job are local admins on the server.

Just wondering if anyone else had come up against this and found a solution!

[jdeanfranklin]

I just dealt with a similar issue when trying to launch DataSync from SSIS. In my case I tracked it down to a problem when using a .sij file in an SSIS job where DataSync was unable to access the credentials and appToken from the Windows registry.

I got around the issue by following the docs to Setup a standard job (headless).

The command I ended up using is:

java -jar <DATASYNC_JAR> -c <CONFIG.json FILE> -cf <FTP CONTROL.json FILE> -f <FILE TO PUBLISH> -i <DATASET ID> -ph true

<CONFIG.json FILE> See Preferences Configuration for details on the preferences file. I just set the values for domain, username, password, and appToken. These are the values DataSync tries to retrieve from the Windows registry when you use a .sij file. There's an example JSON file on that web page with just those four values.

<FTP CONTROL.json FILE> See Control File Configuration for details on the control file. It's not obvious, but I used the DataSync UI to generate the control file from my .sij file. Load your .sij file, click the "Map fields" button, then click "Advanced Import Options". Scroll all the way to the bottom of the advanced options and click the "Display Control File" button. Copy the JSON config from there and save it in a file to use for the control file.

It would be really nice to be able to use the -c parameter with a .sij file for headless operation, but that's not currently a supported option.