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.
| Author |
Topic |
|
AnuVijay
Starting Member
32 Posts |
 Posted - 2011-08-22 : 01:39:07
|
| How can i read the name from a file and insert the value into a table while importing? Thanks in Advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-22 : 01:42:23
|
| are you using flat file source or for each loop or script task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
AnuVijay
Starting Member
32 Posts |
Posted - 2011-08-22 : 13:05:57
|
| Thanks. I am using dbase files. SSIS has to read the particular string from the file name and search that string in the SQL table (which am keeping to maintain the branch names) and inserts the correponding values into the destination table while importing the particular dbase file. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-22 : 13:15:02
|
| you can do it by using a foreach loop. then add a variable for retrieving filename inside, apply substring to get required part. use exec sql task for the search and data flow task for insertion to the table from dbase file.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SSIS