Phil Parkin (5/21/2010)

---

da-zero (5/21/2010)

---

Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent...

Yeah, I'm very fortunate to have never worked with Access before, so I didn't realize the getdate() function doesn't exist in Access. Apparently Now() is the equivalent (Google is your...

Can you show us the query that you are using?

If it is just nvarchar to varchar casting, do the following:

create a global temp table (or a fixed staging table, it doesn't really matter) that has the exact same structure...

Has the number that comes from the input file always two digits after the decimal point?

sachinrshetty (5/21/2010)

---

Hi I have used query in my source but how to write query to fetch rows containing todays date only.

I have used below query

SELECT ...

You have two options:

either filter on the data when you select it from the Access database (with a WHERE clause or something like that).

EDIT: Phil Parkin apparently already suggested this...

Can you give us the exact error, the expression that you use in the derived column editor and some sample data?

tommyh (5/21/2010)

---

da-zero (5/20/2010)

---

Why is the correct answer 4?

I count 7 types of indexes:

clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.

See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.

Even in the explanation given I...

Why is the correct answer 4?

I count 7 types of indexes:

clustered, non-clustered, unique, index with included columns, indexed views, full-text and xml.

See http://msdn.microsoft.com/en-us/library/ms175049(v=SQL.90).aspx.

Even in the explanation given I count more...

I think you have to deploy the entire cube.

But I believe that won't take so long, unless there is massive validation to do.

The following set-up should work:

in your script task, create 3 variables that will hold the counters.

Create a nested if then else statement in the Input0_ProcessInputRow method, which checks the value...

To be short: you can't do dynamic column mapping with out-of-the-box SSIS. The metadata will always be screwed over.

The only option is to use script tasks/components to dynamically read/write your...

Not 100% sure, but I thinks this is how you should do it:

1. Take an Execute SQL Task and execute your stored procedure there with the following code:

EXEC my_stored_procedure my_par1...

Try running the package in 32-bit mode. 64-bit and Excel gives problems.

If it still fails, let us know.