I am trying to figure out your concern over the duplicated data.  Yes, the data is dupicated from the base tables to the indexed view, but this is controlled by...

How would you run an SSIS package from T-SQL?

Can you provide the DDL for all the tables involved?  In the script, be sure to include the collation of the character fields.

Not familiar with 7zip, but this doesn't look right to me:

Arguements: e @[User::FileName] -o:c\dep\unzip

Not sure what you need, but I think the use of the SSIS variable is incorrect. ...

Glad to help!  Would like to know if it helps with the other issue you mentioned about all the jobs ending at the same time.

Without out going into any details, yes you can.  You would also use the File System Task in the For Each Loop Container for moving and deleting the files.

Kurt,

I am assuming you are using sp_add_job in your stored procedure to create the jobs.  You can add a parameter to this procedure, @delete_level = x.  The value for x...

Stephenie,

Actually what you did makes good sence for the data warehouse.  You don't necessarily want to use natural keys in the data warehouse.  Conforming data means coming up with a...

Whatever.  It seemed all my suggestions were wrong, regardless of what was said.  So it doesn't matter.  Also, I did say use what I provided as a start, not a...

Gova didn't.  He provided sample data and what he wanted, but didn't provide a sample input and desired output.  It would have been better to say given this date: 8/12/2007,...

gova,

It would be beneficial to all if you provided complete information up front; sample data, sample input, and expected results.  With out all that, we are just shooting in the...

The big question that has not been answered, is what type of application is going to use the database.  Again, using a ooak or synthetic id needs to be balanced...

Can you post the DDL for the table and the queries you are having problems with?

Okay, you are talking about a synthetic key; one that has no actual relation to the data being stored in the record.  The answer comes down to this, it depends.

What...

From what I can see, you have the file setup correctly.  Perhaps someone with more knowledge of BCP will see something I am missing.