You need to make sure the account running the job has access to the WSDL and remember the WSDL is loaded to a temp directory in my case this was...

Attached is a screenshot of my data quality flow. I like this because no matter how many fields you need to check it doesn't get cluttered. All the checks are...

Same version for both.

same issue I have and same version. Like you said in the header only you see it. But the restore source in the mgnt studio dialog is blank.

v 4035 is...

Thanks for the ideas.

Makes sense, I like the idea of only duplicating a few rows (the ones that fail).

Maybe this was just a typo but wouldn't you enter the variable name Ivan_Test in the readonly or readwrite variables and not VAR_TEST?

I just wanted to clarify.

The attached screenshot is...

Thanks for the info.

I found that I can't restore the backup created with the copy only clause in mgnt studio.

The restore source was blank.

I scripted it using the following...

Where is the variable being used?

From what you said I'm going to assume your using a script task. Do you have the variable specified in the script task under the...

Tim,

lets say you have 30 columns in the data flow and you are doing checks on all of them, would you have a single derived column component with 30 additional...

I did get data to transfer using the OLEDB connection. It wasn't pretty but the data made it.

On the ole db connection click properties and go to the "ALL" tab...

Bill,

here is a screen shot of All the properties from my pervasive OLE connection manager in SSIS. The interface is different but the properties are the same. First off...

Bill,

Running through the wizard now. First off I was not able to test the connection getting a strange error about unable to un-initialize since the object is open (after some...

I have not done this using the import wizard, but I would think it's the same setup. You mentioned the data source on the OLE setup. I'm not sure what...

I thought about the derived column idea, actually that would be good since I would only be duplicating the number of columns equal to the number of columns that need...

We've been doing this for a couple years currently on v9.5

I use the OLE provider for pervasive. Setup with the location being the server name or IP and the server...