[font="Comic Sans MS"]

Simple Ones:

----------------

http://aspalliance.com/1167_A_StepbyStep_Approach_to_Creating_a_Web_Service_Task_Using_SQL_Server_Integration_Services.all

http://www.codeproject.com/KB/database/webservicessis.aspx

For more/complex w/s see:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61360/

http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html

Hope this helps 🙂

[/font]

[font="Comic Sans MS"]

Does this help? http://goo.gl/PkyB

[/font]

[font="Comic Sans MS"]

This is not a very good approach but an alternative.

1) Use a foreach loop container to loopthrough the file(s) - if found it will process.

2) (Optional) If...

[font="Comic Sans MS"]

Duplicate post.

Use SCD component - for a heads up you may refer to:

http://www.mssqltips.com/tip.asp?tip=1442

[/font]

I didn't see the originial question first :hehe::hehe::hehe:

[font="Comic Sans MS"]

Remove or update?

Try - slowly changing dimension component ...

[/font]

mikefemenella (12/30/2009)

---

I can't believe that source::name and source::description are my only choices, there has to be a way to tell what called me outside of the source:: variables and that's...

[font="Comic Sans MS"]

You are not doing it right.

As I said - did you read it through?

http://www.sqlis.com/post/Easy-Package-Configuration.aspx

This is for SSIS 2005 but it's no different and here is the...

[font="Comic Sans MS"]

If this is on package level - it will be executed twice before and after every single executable. So you would definitely need some logic on the stored...

[font="Comic Sans MS"]I am totally lost here 😉

The OLEDB...

[font="Comic Sans MS"]

Does this mean a developer need to put a total of 10 'generic event handler' on pre and post execute steps in case a package loads 5 table?

The...

[font="Comic Sans MS"]

Hello Syamala

You have 2 options here:

1) Use expression to create files dynamically. That is new file for every different run or new file for everyday. You would...

[font="Comic Sans MS"]

Don't mean to offend you - but would it be possible to tell what exactly you wish to achieve here? Things that you wish to achieve ...

[font="Comic Sans MS"]

No problem 🙂 glad to be able to help.

[/font]

[font="Comic Sans MS"]

Hello there - you need to understand how xml configuration works.

Please see : http://www.sqlis.com/post/Easy-Package-Configuration.aspx

On the menu bar, point to DTS, Package Configurations… or right-click on the...