Change your statement to

INSERT into tbl1 select * from tbl2 where export_id = @GlobalParameterVariable

Then click on parameters button.   If that doesn't work, (it works on my machine), you might...

If you are looking for words that starts with table, then use LIKE 'table%'

If you are looking for words that end with table, use LIKE '%table'

I'm not sure what you're...

Cool,

I learned something too.   I've done literally hundreds of DTS packages and have never messed with the error handling.  I'm assuming now that the trans error is global for that transformation...

I think your non-exiting loop is caused by you using the same recordset to update as well as add new.  You could test this by creating a new recordset just...

Can you post your new code?  

Maybe it's not this field, but another field that's causing you all this trouble.  Have you tested all of the other transformations to see if they're working correctly?

You can use a Dynamic Properties Task, or you can run this script as an Active X script task before you do your other steps (code is directly off of...

I notice that your loop is  before the last keytest check (keytest <> "true". Wouldn't you want that to be after the end if instead?

Have you run this in QA and looked at the execution plan for both an indexed table and a non-indexed table?

That might point you in the right direction. 

Have you...

I think you're running into problems due to using reserved words and functions as your variable names.  I know you need to use Year, Month, Day and Date, but maybe...

Couple of things, one minor, one major.

Minor:  You can now use me.fieldname instead of the forms!...

The major advantage is it's checked during design time and you don't have to type...

If you're looking for a SQL Server edition that you can use for free, especially as a developer, you can download the MSDE.  You have to use the client tools...

Another consideration, although a small one, is the addition of another field that must be maintained and the space that extra field takes.

One datetime field is 8 bytes, 2 is...

Here's how you can NOT manipulate the string, but pass the dbname as a parameter to a stored proc.  It's slower than a stored proc should be, but it's easier...

Like Steve said, you'll need dynamic sql.  Just create a stored proc with a parameter for the DBName and build your dynamic sql using that parameter. 

If you need your...