March 22, 2007 at 2:31 pm
Hi i need help on this,
i created a package in SSIS which imports data from excel workbook from sheet 1 into sql database in table a .Now what i want is to add one more source i.e sheet 2 to the same package and get the data in table b in sql server database.
in other words i want to add one more source and one more destination to the same package how can i alter the package and what are the steps should i follow
March 22, 2007 at 10:04 pm
hi!
u must be having the .dtsx file located either on the file system or on the SQL Server where the package is currently deployed. Then by using the VISUAL Studio 2005 you can open the specified package in the studio for modifications and the tasks that u want to do. like another OBJECT FLOW TASK and define the Source and the valid destinations.
test the same package again after modifications.
As far as deployment of the package is concerned, just deploye the same using the studio only and the execute package utility command for execution.
Nitin'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply