I have been contemplating similar. My approach is to have an 'inbound' folder where people will place the spreadshhet to be loaded. The SSIS package runs a for each loop...

what are you expecting to see and whar are you getting back. A few more details would usefull to help you.

Ells.

Thanks,

I had not really considered using the forum or internet in that sort of way. That has certainly given me something to think about.

Many Thanks.

Mark

I had this conversation with another MCITP and he wondered where the value was. He had learnt along the way to getting certified but was not sure that he was...

Thank you very much.

Ells.

🙂

Apologies for pinching someone elses thread. I am looking to do 70-433 and the accompanying MCITP.

One of the key criteria of a good technical book for me is if it...

Is there any event handling \ error logging in the package?

Ells.

I have had similar problems with files and directories. I am assuming that the machine that you are running on and the account it is using can see the directory...

I am not sure what is causing the problem but it does appear to be some sort of data overflow. If or when it comes back have a look at...

I am assuming you are using two machines. I am assuming that you are editing and saving on machine 1 and then moving the solution to machine 2 and opening...

I think google > SSAS data types

was the first result.

Hi,

I have come across similar before and the problem I had was a known bug at one point. which version of SQL Server and service pack are you using?

If it...

Is it a regular load that you want to schedule?

If you are asking for a simple step by step to do this then

1. add a flat file connection manager to...

I think what Lynn is saying is -is it the same file you are opening?

in 2005 open the solution, in solution explorer right click and get the properties of...

Create view Employees as

(

Select sum(employees) as EmployeeCount,

2001 as year

From YourEmployeeTable

Where ’01-jan-2001’ between start date and end date

Group by Year

UNION

Select sum(employees) as EmployeeCount,

2002 as year

From YourEmployeeTable

Where ’01-jan-2002’ between start date...