Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS help

Author  Topic 

prasath9191
Starting Member

2 Posts

Posted - 2009-01-20 : 11:06:11
hi,

How can i read the inputs from a file...

The input file contains parameters which as to be passed to the stored procedure or insert statements.

The format of input file is

1 22 33 44 55
23 45 67 99 00
.
.
.
.
n

so i need to assign the value extracted from the file to stored procedure ......

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 11:40:11
create varaibles in ssis to hold values. use dataflow task with flat file source to get values from file and assign it to created varaible.
Go to Top of Page
   

- Advertisement -