I'd like to see a follow up article from the other side of the fence. De-normalizing the databaase for datawarehousing/reporting.

In my current contract, where we are building a small datamart,...

So does the destination table just have those two fields?

If that's the case, it would probably be better if you import the data into a staging table. Then, using a...

quote:

---

... One of the columns is a list of names, sometimes empty, sometimes with one or more names separated by a comma....

Put a ActiveXScript task in your package and add a MsgBox to echo what the connection settings are for the Excel file. That way you can be sure that the...

Take a look at the following,

Versioning Stored procedures only

http://msdn.microsoft.com/library/default.asp?URL=/library/techart/sql7storprocvers.htm

SQL Source Control 2003, very promising product

http://www.skilledsoftware.com/

Good series of articles by Steve Jones

http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp

My tool of choice for admins not developers

http://www.embarcadero.com/products/changemanager/index.asp

Hope this helps

Phill...

Does the package execute successfully in Enterprise Manager? What version of SQL are you using?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Check the indexing on the table you're inserting into. Check 'Optimizing Bulk Copy Performance' in books online.

If you export the data to a flat file, use Bulk Insert to import...

quote:

---

In DTSRUN command, I have seen people using an encrypted package name. How do you do that?

---