SSIS samples rows in Excel. It looks like it examines the first 8 rows.

Search for this phrase to learn more. 'ssis typeguessrows excel'

A couple of things.

1-Script out the structure of all tables. Then you can search other tables for columns named the same as your primary keys. The assumption is that the...

I'll ramble a bit here so feel free to ignore if this doesn't apply to your situation.

If you are modeling after paper or excel forms then you are essentially saying...

See below for a guess. I have used an artificial key which some may disagree with.

All calculations, incidents of a particular type or subtype, incidents per week, incidents per...

This may help

http://msdn.microsoft.com/en-us/library/ms345158.aspx

Phil Parkin (2/4/2010)

Wouldn't this fail at the import stage, because SSIS would validate the number...

CirquedeSQLeil (2/3/2010)

emily-1119612 (2/3/2010)

GilaMonster (2/3/2010)

No. The DB is in...

GilaMonster (2/3/2010)

No. The DB is in simple recovery....

Thanks for your response. I'll add a bit of info. The archive/backup process is during a 2 day window of inactivity in the system so the performance hit of growing...

>>But i want to retain the same null values.

You question seems to indicate the following article may be helpful.

http://en.wikipedia.org/wiki/Null_(SQL)

I am going to guess and say you want...

One approach would be to import all the data a table with 9 columns and then parse out the primary column into the other columns.

CREATE TABLE Test

(

[All] varchar(20),

[1] varchar(1),

[2]...

Relaying can be controlled by IP address. Are both of your processes using the same IP?

In an Access 2000 ADP I have you can go to File>Connections.

Your question is quite broad which is probably why you are not getting a lot of answers. Generally in an professional environment you don't have a lot of choice, meaning...

Start here: http://msdn.microsoft.com/en-us/library/ms190630.aspx