Phil,

As usual, a simple solution to an annoying quirk of SSIS - Thanks. In this instance I am acutally only interested in the date so I have done a...

I expect that data is written in its RAW state. This is a standard method of passing data from one package to another and is proprietry to SSIS.

Tortiose subversion and Mercurial Hg are both free Source code control packages. Of the two, I think Mercurial is probably better for managing SSIS because of the number of...

how are the tables exposed. Are they on a linked server.

Can you ask the vendor for table definitions. You will probably find that you are not even looking...

I was under the impression that you can output data to Excel from SSIS but you can't format it; which it sounds like it is what you are trying to...

That looks like a badly formed query. You are missing a 'WHERE' and a field/column before the comparator.

Excel is definately the poor relation when it comes to reading and...

UPDATE:

Found half a solution so I am posting it here in case it is useful for anyone else.

I have created a synonymn for the table

CREATE SYNONYM [dbo].[MyTable] FOR [Dev].[MyTable]

You...

I have just run into the same problem :angry:

Minor bit of speen venting. Why on earth woudl anyone want to use Progress for modern applications! the database technology is...

Ok,

This is what we did.

Package scoped variable intIsGoodToGo (Int32)

For-loop with Eval Expression of 1==1 to keep the package constantly running

Konesans File Watcher looks for the file to arrive or change...

Nothing. I don't get the script editor window, which is why I assumed that I needed the full copy of VS to use scripts.

Add a Script task to the...

Thanks PM.

I'm sure I tried that previously with no success but it seems to be working now!

Thanks to both..

The sproc gets fired up to 18 times, but by different tasks, which is why I wanted to use a package level variable.

I didn't want to use the...

What changes between the 30 scripts?

If it is just the table names then I would look for a ForEach loop solution.

Phil,

That would work but we try to avoid inline SQL tasks in our packages: where we need to use SQL to upsert data it shoudl go through a stored procedure....

Phil,

Thanks once again for coming to my rescue.

Yes, there will only be one batch per package execution

create table dbo.batchHeader(batchID int identity(1,1), description varchar(200),filename varchar(200))

create table dbo.batchLine (batchID int, partno int)

Import...