Job still fails when running from SQL Agent.

The error is coming from the OLE Provider for pervasive.

"Pervasive.SQL V9 OLE DB Provider" Hresult: 0x80004005 Description: "-1305: No such table...

I am now able to run the package from the command line using the dtexec.exe from the Program File(x86) directory.

Here is the command I used to launch the package:

"C:\Program Files...

We use standard and we use SSAS. The reason being we don't have the budget, and at this point don't have the need. Combined rows for fact tables between all...

First thought is use SSIS to extract and tidy up the data before it gets into the warehouse. I say this becuase you mention running AS and RS against it....

Use a script task to validate each file. In this taks have a variable for capturing the file name and path and a boolean for indicating failed validation. Next, use...

I will give offline thing a try on monday.

Also the delay validation only appears to affect the runtime validation. I didn't notice any difference.

My work around to the slow loading...

One method we used in the past when doing Lotus Domino development was to format the report rows as html and the link called an agent similar to a web...

Jeff,

I agree but if you didn't use SQL what method would you use in SSIS?

Also here are some SQL test scripts I used thought I would include in case you want to test.

use Testing

go

-- create / reset receiving tables

if exists (select name from sys.tables...

soorya,

This is what I came up with.

in the data flow task add a derived boolean column to act as an flag indicating if a special char exists.

If you have multiple...

Tier is obviously a dimension that should have a key in the Fact_Sales so users can view information based on the tier.

Your saying you need a dim structure that supports...

Not sure I follow you. Are you getting an error somewhere or just looking for a way to detect and redirect rows that contain these "special" characters?

You should be able to use the OLE cmd in a Data Flow Task and isolate the record with the highest version using a subquery and the OVER clause.

Such as...

Found this posting to accomplish the same thing if anyone is interested

http://jessicammoss.blogspot.com/2008/05/ssis-configuration-to-configuration-to.html

when the script task is in the loop it will execute for each file name retrieved. Make sure a variable is setup in the for each container to receive the...