You can multi-cast and then insert into a single table.

You have options here as well. You could use a UNION ALL to merge your Multi-cast output together into a...

So I think you are trying to create 4 records for each record coming from your text file.

For this, you can use a Multicast component in your data flow -...

The SQL Job Agent is designed to execute asynchronously. Rather than fight this with something in a batch file that waits for the status of a job to finish,...

You can do this in a lot of ways with SSIS / SQL Server.

First, if you have several independant packages, you can schedule them using the SQL Job agent. ...

After the cloning, I assume you will change the IP address and server name on the cloned server. The server name change will end up with the @@ServerName variable...

Ok, you really need to search a bit before posting.

There are lots of ways to do this and several articles on this site alone.

http://www.sqlservercentral.com/articles/Reporting+Services/62731/%5B/url%5D

You would need Excel installed.

What you are planning is probably not a good idea. Opening an Excel document from within a service context can be full of problems. ...

Correctly normalizing this, your "little" table should reference the Entity the address goes with and the Address and Address Type. With this model, you would not need multiple Address...

You have a field length specified for an attribute in one of your dimensions that is shorter than the data in the database field.

If you turn on identity insert, you can insert. Including the field is a safer approach than exlcuding it based on it being an identity column.

As far as the...

No problem.

I would suggest you start a new thread if you have additional specific questions.

Anything you can do from the UI can be done through T-SQL. One easy way to see what you need to do for this is to go into Management...

Why not just use a Data Flow and use the sp_HelpDB stored procedure as the data source?

SSIS 2005 is a generation 1 product. Informatica and DataStage have been around for awhile. They currently perform better than SSIS. Most of this is simpl due...

Let the OP do some of the work...