I have also just realised I pasted this in the wrong forum (should be in 2008)

I will now be avoiding the wizard too!

Cheers for the help

I have just saved the file into a CSV file and ran a bulk insert and it went straight in.

I wish I knew why the export wizard didn't work though!

s_osborne2 (8/14/2013)

This is really strange. I've just created an SSIS package manually (i.e. not through the import wizard). If i say that the excel source has column headers in the...

Thats correct, its...

No 🙂 there are no Nulls to insert.. it just doesnt like it when there is a...

CREATE TABLE [dbo].[SystemProducts](

[ID] [int] IDENTITY(1,1) NOT NULL,

[SystemID] [int] NOT NULL,

[ProductID] [int] NOT NULL,

[Code] [varchar](50) NOT NULL )

I have also uploaded a few rows in a file..

The column status returned was: "The value violated the integrity constraints for the column.".

(SQL Server Import and Export Wizard)

is the error message.

When I open it up in Visio...

You can, but best practices state your shouldn't use the default port

kanchankalra85 (8/13/2013)

Can someone please explain what is the purpose of execute permission? What is the drawback of granting execute? Does it cause lot of performance overhead or does it...

If it is an application account, you may have a config file with the password stored somewhere.

If not, reset 🙂

If you come accross any crushed ice making solution, or even cubed ice making solution - let me know

Give it a try 🙂

All the principles are the same but the screens look different. The...

Back again! I changed step 2 to use the above and it worked fine.

Step 3 is proving more difficult..

select @backupcommand = ''Backup database '+ dbo.quotestring(@DatabaseName) + ' to...

Erland Sommarskog (8/8/2013)

So did you read my post to the end and tried the...