Thx wyliec2 - i changed the job under the sql agent to run using the cmdexec property and it works fine.

I found the following post in the MSDN forums - unless the scope of SSIS has been updated and the above doesn't work, looks like you'll be doing it long...

I've imported data from Pervasive to SQL, and can think of the following solution, although I havent tried it...

• Create a datareader connection for the Pervasive connection
• Configure using an ODBC connection...

Cheers John that works a treat...

got some brushing up to do on my t-sql code!

I have several ftp tasks running under several ssis jobs, which are in turn controlled by the SQL Agent.

If you look at the properties of your FTP connection in SSIS, is...

Does the SCD work with an external connection manager, such as an Excel connection? When configuring the SCD, I only see an OLE DB connecftion option.

Found out what the problem was - as the value in the data table is short, fuzzy lookup cannot find a match. Setting the Exhaustive component property of the lookup to TRUE...

Could be a couple of things - check the port and possible use of passive mode in the connection.

Are you accessing an internal or external FTP IP address - check...

Can close this - I rewrote my dataset query to get the results i needed.

Well - am getting further - thought I was doing something dumb.

The field subtotal needs to ref a report item and not a dataset value, that much I found out....

Thx a lot...I feel a bit sheepish having gone off on the wrong track...

Looks like I've got a lot of learning to do.

Thx again.

I suppose it might make it a bit more logical if I tell you what the goal is with the data - I can do in several steps by creating...

Thx!!!

That has worked a treat, and given me a good way to understand it.

Spoke to Pervasive, they say there are no ODBC drivers available which are seperate from the client\workgroup install.

So back to my original, question, if a client was installed on all of...

Problem is though, I cant create a system DSN as there are no Pervasive drivers, ODBC components available on the SQL server. They are all embedded in the pervasive client....