In Events remove everything.

Then add the Scan:Stopped event.

In Data columns Add the IndexID, and ObjectID columns. (Remove any you don't want.)

Then you can use the indexid to run this query

Select...

that works, but are you control how/when this executes?

what if this task/procedure runs twice, at the same time?

Say it is called twice the first instance inserts data into the global...

For what your doing Dts would take a little time.

so simple insert / select statements should work.

Declare @maxid int

Set @MaxID = select max(FieldID) from DatabaseA.dbo.TableA

Set identity_Insert DatabaseA.dbo.TableA on

Insert into DatabaseA.dbo.TableA...

There ya go, modify the query I gave you and it will work.

If you execute a

EXEC master..xp_cmdshell @bcpcmd

It is actually starting up an other connection. the data is not available to that new connection only the connection that created the temp...

We need a little more information on how your contribution table looks.

create table #Contribution (pk int identity, Contributorid int,

Amount money, ContributionDate datetime)

insert into #Contribution

select 1, 100, '1/01/2005' union

select 1,...

Whatever your text qualifier is, you have that in your data.

If your text qualifier as " (Quote) one of your fields has actual data with "Quotes" in it.

I am a little uncertain of what your asking.

First Sql server stores dates as 2 integers, first int = days past 01/01/1900, and second int = milliseconds after midnight.

if your string is...

An easy tool to use is sql profiler.

Don't necessarily recommend for Production, but certainly can be used. You can select different events.

The scans event class will show you table, or...

Generate Sql Script does work.

In Enterprise manager, Right click on the database you want.

Select All Tasks --> Generate Sql Script.

Immediatelly go to the Options Tab and select Script Object Level...

In books online it discusses how to estimate the size of a table.

The "Formula" you show is way too simple. There is a space cost for each different datatype, and...

What was your error message?

make sure ian user has access to the db.

There is no way to "Mask" the value natively in sql. There are several articles that introduce encrypting.

Do a search on this site, and you will find tons of information.

I...

@DQV4 decimal(18, 0),

 @DQV5 decimal(18, 0),

Your error is in your parameter declaration.

decimal 18,0 is equal to an 18 digit number with no digits to the right of the decimal

it should be...

Even Better.

Select *

From Information_Schema.columns

where column_Name = 'YourColumnNameHere'