willmiss20 (8/9/2009)

---

Thanks for the reply.

The constraint is set to 'Expression' only.

I have been able to now get the package to work, when I set it to 'Constraint',...

willmiss20 (8/9/2009)

---

I believe I have narrowed the problem down to the precedence constraint.

When I remove the contstraint, the Script task and data flow task execute as expected.

The precedence task...

CozyRoc (8/6/2009)

---

How are...

CozyRoc (8/6/2009)

---

How are...

Have you considered using BCP? That is a great tool. You can call it from within an SSIS package for each of your source files if required.

riga1966 (11/4/2008)

---

I have about 40 source files.

They are supposed to be loaded into staging tables

and later inserted into Data warehouse Dimension and Fact tables.

So far I see a few ways...

Rupashri Gulawani (8/3/2009)

---

There will not be any straight forward way of doing it. I can suggest few options:

1. Write a code which will generate an Export package for you at...

Try this:

Me.ReadOnlyVariables("varname").Value

You will also need to add the variable to the ReadOnlyVariables or ReadWriteVariables in the Script Component properties of course.

How about BCP? You can even call that via the command line in an SSIS package.

Doing it all inside a Script Task should be the last resort in this case.

Please provide more information. Your code, perhaps the wsdl, etc.

It really depends on the web service and what it expects. It may support passing an empty string or null, or it may even have an overload that doesn't expect...

I believe you need to set up "delegation" in Active Directory. That's usually the issue when you see the anonymous login message and there is a double-hop in process.

Again, it totally depends on the requirements.

How are you loading the data? Data Flow, Bulk Insert or something else?

Just for the record, I never said they can't support custom stored procedures. I've used them all and getting them to work with custom sprocs is a hack most of...