Hey Johmar,

You have your CREATE TABLE statement slightly wrong.

When you define the Column names, remove the 'as' keyword.

You only need

CREATE TABLE Dynamic (First int, Second int)

With that removed, it works!

Clive...

Sorry...It's way to early to be trying to answer questions...especially before having a coffee!

I forgot to state that you need to code in a connection to the SQL Server before...

Yes. You can!

If you right click on the DTS pane and select properties. In (I think) the second tab you can define your Global Variables for the DTS. ...

I'm not sure if there is a set timeframe to measure growth. I have not come accross one.

You mentioned it will grow to 60Mb with all your indexes. ...

I think you will need to write a script that will search through the string until it finds a comma and then write that portion of text to a variable....

Sure.

Create a DTS and drag an ActiveX object onto the DTS pane. Open it up and you could create something like this. It's pretty basic and has no...

You the man!

That was so obvious when I looked at your code! Cheers!

Clive Strong

clivestrong@btinternet.com

OK...One idea I have is this..

If you know the format of the AS400 tables, you can create an ActiveX script which connects to the AS400 and also your SQL Server...

Hello,

You say the date is stored on the SQL Server. Is this the system date on the server? Or is the filter date stored within a table?

Either way,...

Hey,

We have a similar issue. We have a table with 12 columns. We do have a unique rowid.

Basically we have the following (cut down) table

rowid

ordernumber

partnumber

linenumber

orderqty

shipqty

backorderqty

This is downloaded from...

You got it.

We have lots of NT Groups around the company. We also have different roles within applications.

So you may have an Admin NT Group, a user NT Group....

Hey,

My personal choice would be to have both NT Groups and Roles! Basically if we have a bunch of users who do the same task, then we put them...

Hi,

I checked the query to ensure it was correct and ran the same query against a restored database on another server.

When I ran it from QA, it was like the...

I'll go with Robert on this one...oh and Steve's suggestion too (well Soccer over here!)

:o)

Clive Strong

clivestrong@btinternet.com

I agree with the Lab approach.

After all, thats how we work. We sit at a computer with an issue, study code, use BOL and try to identify a problem...