this is simply and exampel how you import data from excel cells.

yes this is working in 64 bit. in fact, all my development are happening in 64 bit

Users who execute packages that include the SQL Server destination require the "Create global objects" permission. You can grant this permission to users by using the Local Security Policy tool...

Check the execution plan and identify high cost operations and try to fix them.

in the execution plan, Tabel Scan, Index Scan, Sort are the costly operations mostly

in your senario, you don't need diff backups. But there are places which has only one full backup for a week. take diff. backup daily mid night. log backups during...

Are you seeing any errors in the secondary server log restorign job history

DBCC Log(dbname)

If you want to find out version information, you can use @@Version function. However, in SQL Server 2005, you won’t get the service pack level of the SQL Server.

If you...

http://dbfriend.blogspot.com/2009/01/how-to-create-link-server-for-mysql-in.html

I am working with Team Foundation Server to do the version controling with SSIS which seems to be a great tool.

It is intergrated with Visual Studio so that you have...

Check this

http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

http://technet.microsoft.com/en-us/library/ms140223.aspx

This seems to be a comple text file which will be very difficult to create from SSIS.

Why you need to generate this file from SSIS?

I had the same issue. But when I aved the password in XML file and load it from package configiuration of SSIS, issue was solved.

I think your query is perfect.

Use this quesry in the data source command.

Use fixed length option in flat file connection manager