I think you just need to use the support article and the code and instructions in the link below. The reason is you need to create the Backup devices...

A skilled person can convert Excel workbook into rows that insert into SQL Server so you need to run SELECT * from any table with Excel and click show results...

Go in SAC(surface area configuration) tool and enable both remote and local, then TCP/IP and Named Pipes and turn on the Browser Service. Then enable all in COnfiguration manager...

Remove xp_cmdshell use use an Agent proxy account the Agent must be admin in SQL Server and on the network and in some cases the owner of the package must...

Collation in SQL Server from 2000 can be applied at the column level but it was not easy but 2005 comes with collation used with DML as I posted in...

Your problems are not related to 64bits but rather source and destination of your package which you have not posted. There is no 64bits driver for Excel but where...

Hi...

The level of .NET framework above 2.0 is not really relevant to the trial version that is the reason it installs even in XP home. And I know system...

Actually collation is used to render any language correctly in any application if started with translated text. ...

I don't understand what you mean by how SQL Server stores Excel objects because SQL Server stores Excel data as tabular data from Excel XP and up because it uses...

You need to make sure IIS is installed before you run the installer or it is disable the SSRS as an option in your choose components. So check control...

What I am telling you is ANSI SQL definition Microsoft and other RDBMS implementation takes versions to be compliant. That is the reason code migration is not simple what...

This should be ok since a change to table A would cascade to table B and to Table C independently.

That is not OK because only one foreign key qualifies for...

You do that with the ReportViewer control in Local mode which means you just use ADO.NET dataset using queries with all RDBMS and even text files. You can also...

I don't know what you are doing but the error is not wrong because SQL Server being RDBMS can only Cascade to one child table because DRI means if A...