You have 2 options :

1. Change the dts package properties to enable logging to SQL SERVER. When the package is executed, an entry will be added to the table : msdb.dbo.sysdtspackagelog...

I think what you need is a Dynamic Property Task. When this task is executed it will assign values to your global variable at run time.

What you need to do...

This version uses the SQL92 "outer join" construct. It still resolves to the same thing as whar Remy wrote. 

INSERT dbo.Contacts(compID, first, last, phone, email)

SELECT ic.compID, ic.fname, ic.lname, ic.phone, ic.email

FROM

No, that will not do. You cannot assign the output value to the column in the CASE statement.

the statement : select ISNULL(COL014, 7.45) AS COL014 would work fine. Prefer...

MSDE installs itself by default to use Windows Integrated Security only.

If you need to access MSDE using Mixed Security Mode you have to change Registry Setting :

HKLM/Software/Microsoft/MSSQLServer/MSSQLServer/LoginMode

From value 1 to...

Yes, you can use EXCEL and its Pivot Table with data coming

from external data sources as long as you can read from these source using OLEDB.

1. Open a new...

Check this link :

http://qa.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

HABIB

It also happens if someting changes in the structure of the table on SQL SERVER, and you do not refresh the table link in ACCESS.

HABIB.

Or use BCP to export the result to a comma separated flat file. Excel will have no problem reading the CSV file directly.

HABIB.

A good design pattern would be to transfer the selected items between the web page and the web server as XML data. Then you can design the stored procedure with a single...

1. Use a dynamic variable task to set up connection parameters at run-time for the destination.

2. Save the package as a structured storage file

3. To help you generate the command...

I found that date formatting is probelmatic with international systems (i.e; French = dd/mm/yyyy).

The best way to pass dates to sql server in any locale is to use a...

There is a tool by Microsoft called SQLWEBADMIN. Look for it in the downloads section de http://www.microsoft.com/sql

You have to install it on the server and allows you to ru...

Changing collations using ALTER DATABASE requires that the database be in single user mode. So it is best to do it one time independently of the DTS.

One things to remember...

Christo has summed it up.

You can comfortably handle that number of records and the high rate.

But to make things even more comfy, ovoid clustered indexes except for a timestamp...