You cannot perform an in-place upgrade from 32-bit to 64-bit.

If you already have a 64-bit OS with the 32-bit SQL, then you can install 64-bit sql on the same cluster....

Use the CONVERT function, with style 101, to convert the datetime to mm/dd/yyyy format. Grab just the first 5 characters, and then do your comparison.

Craig,

I'm having problems loading this much data into a sample table. Can I get you to export the data into a new table in a new database? Detach the database,...

...In your attachment are several rows with "NULL" instead of any data.

DECLARE @test-2 TABLE (

RowID INT IDENTITY PRIMARY KEY CLUSTERED,

Name varchar(10),

Gender char(1),

Age tinyint,

[Group] char(1));

INSERT INTO @test-2

SELECT 'Jim', 'M',...

Please be sure to come back and let us know how it worked out for you.

Alvin,

Why use a Script Task to build another variable when you can do it from the expression property of the variable?

Soulfly73 (10/7/2010)

Thank you for your reply.

I indeed can get the supplierId from the filename, but I cant figure it out to use it as a variable and insert it...

sbrochu (10/7/2010)

T0.[Name] AS 'ComputerName',

--count( T0.[Name]) as 'Execution Count',

T1.[Domain] AS 'Domain',

T1.[Last Logon User] AS 'Last Logon User',

T2.[Start Date] AS 'Start Date',

T2.[File Name] AS 'File Name',

T2.[File...

sbrochu (10/7/2010)

Are you saying that the filename contains information to be able to determine the SupplierID? If so, you can have this go to a (package level) variable, and use it...

Assuming that the parameters are going to be the variables that you declared and initialized, then this looks good. Just ensure that you remove the declaring/setting of the variables!

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

craig-404139 (10/7/2010)

craig-404139 (10/7/2010)

@GroupNo = GroupNo = case....

@Prefix = Prefix = LEFT.....

Looks like you are setting the...