Hi,

I think your syntax is correct so maybe it is the result from the SQL Task. Try testing the precedence by using the most basic SQL you can in the...

Hey,

Thanks for you response. I have added these settings to my SP and now I can select the columns and preview the data. However now I get the following error:

[OLE...

I think the SQL Server 2005 Express Edition is what you are looking for.

http://www.microsoft.com/sql/editions/express/default.mspx

Regards

Daniel

Thanks for you idea which I will try. I am hoping not to have to change the packages because I have quite a few.

I am executing the package on the...

I'm not sure why there should be a diffence but I expect you might get a better idea if you can read the error message.

Try enabling logging in your package...

I don't know the answer for this but I had a thought.

Are the Regional settings under the control panel based on the User profile?

If so try logging in as the...

I'm curious as to what you are trying to achieve with SSIS however I'll try to help out.

1. You can use the Package deployment utility under the project property pages...

For the first part of you question you need to use a variable enumerator which you populate using a script task.

I wrote this script task below to do a...

Sounds like this might be easier via a simple update statement?

Regards

Daniel

It is a little confusing to understand what you are trying to do.

Can you not use a Derived Column in the data flow. Even better can you join the tables...

This took me a little while to spot but you can do it through variables quite easily.

Right click the For Each container and choose edit.

On the Collection tab under the...

I've created a very basic example for you below of how you can do it.

Regards

Daniel

'=======================================

Module Module1

Const FOLDER = "C:\Windows"

Sub Main()

...

Not entirely sure what you mean by connection contexts but here are a couple of ideas...

You can set the connection string used by you connections via the ConnectionString property on...