Terms: DTS = 2000 SSIS/DTSX = 2005+ 1) We Need the error. You may have defined the columns of the Excel file incorrectly, as well as defining the other file definitions
2) If you are adding/removing field/columns from a table, you need to rethink your table design. You should not have to add/remove fields regularly, as i understood your 2nd note. Instead look at generalizing the table for each of the clients and then attaching some IDX and STATS to the table to help speed it up for each of your client(s). On Monday, March 12, 2012 11:37:11 PM UTC-5, Rakesh wrote: > > hello I am having some problems with SQL server 2005 > > 1) How To import excel file in SQL Server 2005 ??? > I am using the DTS Package for data import and export. It always gives > the error... > I am not able to import the excel shit to SQL 2005 table.. This > process works for SQL Server 2000 > > 2) Also when I change some columns or add columns to table Every time i > used to keep the track what i have changed > using alter statement. I add the row to tables. If i script the table > defination the table is newly created by dropping old table. > Is There is any way alter table defination without loosing the data in > the table. > I am having 730 tables in my Data Base. When i release the version of > my software every time i have to keep the track for all > database and for all clients on which date which client is given the > updation. I having more than 100 clients and 2 client > companies also their clients. > > > -- > Rakesh Hendre, > Sr. Software Engineer > Brilliance Software Systems. > Mob : 9960001862 > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
