Yes, SVN documentation has been reviewed. The largest issue for using SVN with database objects seems to be the inability to identify easily which objects have changed from one...

My thought is that I would rather have the time stored as Local time, with the local time zone indicated, so that if you wanted or needed to convert to...

Unfortunately - you can't do that. The conversion from 6.5 to SQL 2000 (aka 7.0) was a Major conversion that required you to perform conversion using the SQL 2000...

Hmm - your Columns part should work. That may be an issue...

So, now you drag a "OLE DB Destination" to your Data Flow, drag the green arrow from the...

One additional note: You DO need to unzip the files into a new folder. SSIS will not read zipped files directly, nor would I recommend that approach anyway....

I can attempt to give you a step by step - here goes.

1) Open up Business Intelligence Development Studio

2) Create a new project selecting Integration Services as the package type.

3)...

My company loads DBF files. In SSIS, you can set up a Data Source for this by using the following settings:

Choose "Native OLE DB\Microsoft Jet 4.0 OLE DB Provider...

My thoughts are that if it is out on the Internet, you are exposing anything you say "to the world". Some of these Facebook entries that I have seen...

Very interesting post! I think one of the largest proponents for why to use stored procedures is the benefit of recognizing what applications perform CRUD operations on each table....

I have had good luck using the OR statement instead of LIKE. Often, I find that the LIKE statement doesn't always like to read the index.

So, when I do...