Yes.

By all means, give him CREATE TABLE permission on one of the schemas in the database.  But know that if you do that, he'll be dragging data in from production...

No, don't assign the same privileges.  That defeats the object of having separate accounts.  Chances are, you don't need to assign anything manually: if you use SQL Server Configuration Manager...

Richard

You might consider a more granular security model, granting DML permissions on individual tables, EXECUTE permission on individual stored procedures, and DDL permissions at the schema level.

I'm not sure I understand your question, I'm afraid.  Where in the package are you using the expression(s)?  When referring in an expression to a variable, you do so like...

Exactly as you did for today's date, but replace GetDate() with an expression using date arithmetic to subtract 45 days.  I don't know the syntax off the top of my...

Are you looking for FIRST_VALUE?  It uses and OVER clause instead of GROUP BY, but I'm sure you''d be able to make the necessary adjustments.

John

Did anybody else who doesn't live in "Washington D.C., the fifty (50) United States of America, and the Commonwealth of Puerto Rico" win a $10 Starbucks voucher in last month's...

Yes, that shows me that there's a Data Conversion transformation, but it doesn't tell me what it actually does.  What does it do that can't be added in the new...

You're welcome, and I'm glad it worked for you.  I know this is probably what you meant to say, but it actually changed varchar to nvarchar.

John

Back up the database and send by internet, sneakerweb or whatever.  Then restore it next to the database created from your scripts, and bcp/SSIS the data from one database to...

Ooops!  No wonder you were so confused.  My apologies.

Right then.  The first thing you need to do is create a staging table.  You only need to do this...

The one that you mentioned in your very first post: