No Problem - glad it was that simple!!

James,

I just created a test DTS package that writes the Global Variables values out to a text file. The variables are empty in the package. I executed the package from...

Sean,

This link is an example of constraint manipulation

http://www.sqldts.com/default.aspx?218

Good Luck,

Darrell

James,

I missed it in the original post - remove the quotes from around the 8 (typeid).

James,

Try leaving the Global Variables in the package empty (delete the values and save the package). I have had issue with this on occassion.

yousef,

It is my understanding that one of the primary benefits/advantages of XML is that the data can be interpreted by a wider range of client apps much easier than the...

Given your requirements I would have to agree with Phil, you appear to be on the right track and the flow Phil outlined should do the trick.

Good Luck,

Darrell

And considering not everyone on this site uses English as their primary language - I am glad I can read the words!

Nikki,

If you go into the Transformations Tab and select "New" you can use the ActiveX transformation which will let you use VBScript to do the IF..Then..ELSE.

You could do something like this:

DECLARE @Count INT

DECLARE @Query VarChar(700)

SELECT @Count = 5

SELECT @Query = ('SELECT TOP ' + STR(@Count) + ' * FROM table name')

EXEC (@Query)

Good luck,

Darrell

I agree with your concerns - it's kind of like the scientific studies from the 60s and 70s - no wonder those rats...

Interestingly enough - just heard a report on the local news this morning stating that identity theft is the fastest growing form of crime right now.

Even though I live out...

Unfortunately I see this like the gun control issue - we can "force" everyone to identify themselves but the hackers (or criminals in the case of guns) can still spoof...

Zaza,

Try this site - lots of helpful information.

http://www.SQLDTS.com

I still can't figure out why these obviously talented people spend their time writing code that disrupts other systems for free when they could probably be pulling down some serious...