Also, presuming 'x', is the only field you're returning, add that field to an index on SubsidairyID, non-clustered or clustered. SQL will prefer that index as it will be able...

If you don't know where global variables are stored then you need to a lot more reading and learning than can be provided in a simple forum response.

Start of with...

Then it should show you what needs to go where.

Did you download the sample package?

Wouldn't it also be advisable to capture the return value from sp_executesql?

eg: exec @rtn = sp_executesql etc...

Take a look at this article.

http://www.sqldts.com/246.aspx

Then do as I suggested and save a package as VB so you can see how the mappings are created. Then add an ActiveScript task to do all the work.

As...

Do you have to generate a new identity value? Can you keep the identity value that's been generated in the source table?

Unless you have other workflow manipulation tasks in subsequent steps, then all you are telling DTS to do is not run the ExecuteSQL task. To prevent the import from occurring...

Sandy

Best thing to do would be to create on datapump task with all the mappings. Save the package as a VB file (via Save as... command). Open the file and...

A good bit of DML & DDL goes a long way. If you provide the query, table structure and index structure we could maybe make some suggestions as to why...

After the data is imported, how are you veiwing it to see it as "ARIZONA ALABAMA STATE "??

If you're looking at it in Enterprise Manager, or the Query...

Not sure about any limitation with the inbuilt Log Shipping. As a rule we don't use the inbuilt log shipping we prefer to use our own T-SQL scripts and have...

Ali, I was going to say we'll forgive you for hijacking the topic, but you've done it four times. Start your own topic and you might get a better response.

Carlos,...

Hmmm ... ok I'm out of ideas. Looks like you've tried all the avenues I can think off.

I'd say the next step would be a support call to MS