The data source you will need is going to be like the one below. Key things are that the employee number is tracked to a unique number for the ...

I am looking at trying to do something vaguely similar to create one package that will take different format files and load them in.

You could still use a...

there is more than one way to skin a cat or in this case design a package.

The for each loop container sounds like a suitable loop for you. I use...

I was hoping to edit that post before anyone viewed it. As I cleicked post my brain kicked in and I remembered scale and precision. Then I guessed that the...

Went to Excel and queried the view with that sql in and Excel gets it wrong.

:w00t:

was playing with decimal last night

select CAST(0.5 as decimal)*2

gives a result of 2

Now this and the arithmetic issue with float are beginning to bug me. I will go through...

Thanks will look at decimal.

Ells.

😎

I thank you. I cant imagine why rhey consider an approximate value a good idea.

Any suggestions for a suitable dtat type to hold the value 10.1 that is not approximate?

Thanks

Ells.

:w00t:

Cris,

I giggled at the thought of the drop down list. You are right I think a simple report where they input the customer number is spot on as a starting...

Jason Miller (8/19/2009)

The employers smell blood and are perfectly happy taking the desperate enough players. Problem is, once things improve, those desperate people will be among the first to...

Michael Esposito (8/18/2009)

---

I am trying to be able to uniquely identify a package being stored in the MSDB. I thought the [id] column in the sysdtspackages90 table would do it,...

A few thoughts.

1.All your packages log to Sysdtslog90

2. Every time a package starts a row is inserted into Sysdtslog90 and the column 'event' shows the value 'packagestart'.

3. Every time...

For a previous company I attended a two day session which included one interview, a raft of tests to make sure I was not an axe wielding murderer. In addition...

yes

If you take the dtail of what you want with you the tutor will be able to tell you. The Exceute SQL task will do exactly what its name is...

http://groups.google.co.uk/group/microsoft.public.excel.interopoledde/browse_thread/thread/2e8fcafdc1104764

I would just suggest googling for the provider by name. Tread very carefully if you dont have a test box to test this on before you go live.

Ells.:cool: