Viewing 15 posts - 1 through 15 (of 395 total)
this is simply and exampel how you import data from excel cells.
April 29, 2010 at 7:09 am
yes this is working in 64 bit. in fact, all my development are happening in 64 bit
April 28, 2010 at 3:20 am
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...
February 16, 2010 at 11:27 pm
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
February 8, 2010 at 2:05 am
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...
February 8, 2010 at 2:02 am
Are you seeing any errors in the secondary server log restorign job history
February 8, 2010 at 1:51 am
January 30, 2010 at 7:23 pm
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.
January 29, 2010 at 12:58 am
January 7, 2009 at 4:48 am
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...
March 3, 2008 at 8:57 am
February 29, 2008 at 8:50 am
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?
February 29, 2008 at 8:47 am
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.
February 28, 2008 at 2:49 am
I think your query is perfect.
Use this quesry in the data source command.
February 25, 2008 at 10:17 am
Use fixed length option in flat file connection manager
February 25, 2008 at 6:57 am