You can do something similar but it would require a short ActiveX Script task before the ExecuteSQL task. This script would dynamically re-write the SQL of the Execute SQL task.

Here's...

If you don't need to import the ID from the spreadsheet then make sure you exclude that column in the transformations tab.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point...

Using the text file connection, DTS will re-create the file each time the datapump runs. To append to an existing file you would need to output to a second file...

How is your app connecting to the server? Are you sure you're connecting to the new server?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

From the Server Explorer pane, add a dataconnection. Then expand the tree till you get Stored Procedures. Right-click on the Stroed Procedures folder and choose 'Add to Source Control'

Then you...

Steve is right, reindexing a clustered index can require 120% of the space allocated to the index.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

If you want to check the available space in the t-logs use,

DBCC SQLPERF(LOGSPACE)

This will tell you the size and the % used.

Other than that, I'd go with Allen's suggestion. Assess...

Just use the CAST, or CONVERT, function to re-format the field when you display it.

eg: CAST(Field as decimal(18,2))

Make sure you put the double brackets on the end, I always forget...

Ditto on the newsletter idea.

I'm betting Frank has his father, mother, brother, sister and wife all subscribed

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and...

Hmmm ... it'd have to be an Analysis Services default. Can you do some sort of display formula? Like only display the date if its > 1/1/1900.

Hope this helps

Phill Carter

--------------------

Colt...

Is there any default specified for the field?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Ok so I'm a stick in the mud

I just think that with our ever growing community (I see more and more users with single figure posts)...

Just what I was looking for to drive my ASP status report.

One other tip for #7, I modified the SELECT statement to be like this,

SELECT TOP...

Ok, now not meaning to rain on anyones parade, I know a majority of the posting is exceptionally helpful, but...

How can people be labelled SQL Server Guru's when a lot...

What sort of connection are you using as the source for this statement? The "Error Source: Microsoft JET Database Engine" would indicate that it's not SQL Server.

Hope this helps

Phill Carter

--------------------

Colt...