Jason Whitney (10/1/2009)

---

jcrawf02 (10/1/2009)

---

Nadrek (10/1/2009)

---

I'm a DBA,...

Arguably you could have the start/end dates at both levels! It really depends on the strategy you organisation takes. You might decide to have a particular promotion running for a...

Hey Jeff,

Good article. It's great that you and others are continuing to drive home the fundamentals of good code practices!!

Rob.

Hey,

If you have the ability to develop something in .NET then that's by far the best path to follow.

You should be able to build a windows service that will monitor...

Great article.

Very nicely explained and a great concept.

Rob.

Great article. I use almost the exact same architecture and it works a treat!

The main benefit that I have found it being able to identify exactly what data in the...

OK sorry for the delay in replying again... not sure what the issue could be without seeing the specifics of package. Have you tried to get a very simple package...

I think this is the misunderstanding.

You can use SQL Express edition as a data source within SSIS however you will need SQL Satndard edition to implement SSIS itself. That would...

MrsPost (12/10/2008)

---

I knew I wasn't explaining it clearly.

...When using the application and going into 'new record' mode on a form the app will grab the value from TableB, increment by...

In that case then these are the two most likely causes of your issue:

1. You've misspelled the variable name. Might sound silly but it's worth checking and then checking again!

2....

If I understand your issue correctly then a script transform is in fact just what you're looking for, check out the following link which should tell you all you need...

Is this a script task (control flow) or component (data flow)? If in the data flow then you can only access variables in some methods, e.g. preexecute, postexecute. From memory...

Kumar,

You need to give more detail before anyone can attempt to help you with this issue.

There is no standard procedure / function etc in SQL Server by this name and...

This doesn't solve the issue you are experiencing but why do you need to have this is a distributed transaction when you are only changing data in one database, the...

Jeff you beat me to it. I would most certainly look at using Transactional Replication to solve this issue, assuming that's going to be suitable for your environment.

However the...