Ok cool.

All the help is appreciated!

- thanks all.

DAB

i've just tried to implement this on an SQL2000 database, but I getting an error on both functions:

Msg 170, Level 15, State 1, Procedure formati, Line 2

Line 2: Incorrect syntax...

Thanks DAB! That's very useful to know. 😀

Nearly there !!

I now have the task completing successfuly, but it appears that the variables aren't updating.

To resolve the error msg,

I basically had to map the parameters to the...

To add further to my confusion - I just checked the table the the parameters are linked to and it would appear the sql task container, is doing what I...

hi

I don't have any example to give you, but as a start point, I would look at setting up an ODBC connection to your AS400, so your going to...

you could schedule a task to run the package ever ?? minutes to check the directory, between set times and set days

thanks - the single quotes were the issue

comes up in red, when I input it into the expression window

ok,

I think I might take the approach of a packages for the data extracts where I need store the data for historical data, with multiple data flows.

I'm new to...

That'll do it. Thanks!

thanks. I've read about that before.

In view of your situation, I would stage the information from your system and then treat the fact table like a slowly changing dimension.

(I'm...

Just curious - what is an accumulating fact table? I've not heard that term before.

As I understand data warehousing, all fact tables are generally speaking - incrementatlly updated.

could you point me in the write direction for some good preperation material for the 70-446 (I was actually waiting for the 70-446 book), but looking at your blog -...

Well,

I'm please to say that I have passed! 😀

For anyone who is interested, my experience / knowledge was predominately from the 70-445 training book. To be honest, I think...