Check this out

http://www.sqldts.com/default.aspx?200

This will help U out alot.

There is no way to do it "Dynamically" the values of the fields need to be known in advance.

You can perform this using "Dynamic Sql" but it will be a...

You will have to learn VBS, but someone can probably help you get the filething done rather quickly if you would post your requirements for the file. and Also calling...

Sure

Insert into new_Table (ClinicKey, ProviderKey, PhoneCallTypeKey, CallDT, ReturnCallDT, DateAdded, DateChanged)

Select ClinicKey, ProviderKey, PhoneCallTypeKey, CallDT, ReturnCallDT, DateAdded, DateChanged

From Otherserver.DatabaseName.dbo.TableName A

where not exists (select * 

                        from New_Table B

                        where a.col1 = b.col1

                            and...

Yeah Yeah, it will be easiest to use select using a query.

Use the coalesce function on the field that U know has nulls.

just do select using query, this is the...

Select Destination, datepart(Datefield), Quantity

From MysteryTable

Where DateFIeld between Getdate() and Dateadd(dd,7,Getdate())

This will return rows,

But can you clarify how you want your output to look

exactly update what column(s) to what values where this criteria is true.

If you can make a select statement out of your rules. then use the from, join where clause with...

Spid is what you get when you log into a windows domain. Security identifier, with your credentials.

Are you installing reporting manager on your machine, or just the client tools?

Does the...

Restore the db to a different dbName or different server, and dts it over.

drop table in original db,

dts data into original db from old db would be easiest.

When you say "Data" are you talking large chunks of data? or just a row or 2?

I've never seen such a thing. Is there any application side caching, that would...

How are you "Connecting" the error indicates that

A) you do not have a valid SPID on the network.

B) your trying to connect using a sql login, but sql server...

How R U Inserting the data?

dts?

If t-sql use coalesce(), or ISNULL()

R U a sysadmin? Sysadmins always create as dbo.

This user should use the dbo.tablename naming convention when creating tables to prevent this.

use sp_changeobjectowner to change owner to dbo.

From books...

I'm pretty sure that the time a index was reindex'd is NOT saved.

In fact, I don't even see a create time.

If I may, Why are you looking for this information?...

Looks like you have the just of it. But I don't know what kind of errors your expecting, I think certain errors will cause the transaction to roll back, and...