Search Results | SQL Server Performance Forums

Migrate MSExcel worksheet sources to SQL2005

Post by: lonskie1030, Apr 5, 2006 in forum: SQL Server 2005 Integration Services

Will this DTS could recur on my 50 worksheets and create new tables for them? I could not find similar article/information related to my problem....

Migrate MSExcel worksheet sources to SQL2005

Post by: lonskie1030, Apr 5, 2006 in forum: SQL Server 2005 Integration Services

Hi,<br /><br />I just want to elaborate what I am about to do here to clarify things up.<br /><br />In my case, I have 50 worksheet in my Excel...

Migrate MSExcel worksheet sources to SQL2005

Post by: lonskie1030, Apr 3, 2006 in forum: SQL Server 2005 Integration Services

Thanks for your reply. Where can I find this DTS feature in my VS2005 - SSIS package designer? Thanks again. quote:Originally posted by smy You...

Migrate MSExcel worksheet sources to SQL2005

Thread by: lonskie1030, Apr 3, 2006, 7 replies, in forum: SQL Server 2005 Integration Services

Hi, Is there anyway I could do to migrate my data on my excel workbook to SQL Server 2005 per worksheet? Meaning, I have to create table for all my...

SSIS Diagramming

Thread by: lonskie1030, Apr 3, 2006, 0 replies, in forum: SQL Server 2005 Integration Services

Hi, I just want to ask, is there a tool that can create a diagram supporting the SSIS package I have created? I would like to know if there is any...

SSIS Diagramming

Thread by: lonskie1030, Apr 3, 2006, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I just want to ask, is there a tool that can create a diagram supporting the SSIS package I have created? I would like to know if there is any...

Audit Table in Data Migration

Thread by: lonskie1030, Jan 5, 2006, 3 replies, in forum: General DBA Questions

Hi, I just want to ask, does SQL Server 2005 support Data Migration Auditing? For example, I have to migrate my table from SQL Server 2000, does SQL...