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 |
|
Arunraj
Starting Member
18 Posts |
 Posted - 2015-01-27 : 09:27:37
|
| Hi Friends,I have files in my local folderLike thisHIST_EYE0001_20150121_1406_SL.TxtHIST_EYE0002_20150121_1406_SV.TxtHIST_EYE0008_20150121_1406_INV.TxtEYE0003_20150123_0800_SL.TxtEYE0009_20150123_0800_SV_APPT.TxtI need to pupolate these files into my local Database through SSIS package.I have the Expression already to pull file with another namebut now the file name got changed the i have changed the name in Expressions also.Then the data is loading wrongly in DBCan any one please help me ! |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-27 : 10:23:14
|
| You'll have to provide a LOT more detail1. the CREATE TABLE statement for the table your package is populating2. the format (excel, csv, tag-delimited, etc) of the input flat files3. a few lines of the input file(s) that work4. a few lines of the input file(s) that don't work5. Any error messages you receive from SSIS when running your package. |
 |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-28 : 07:34:57
|
| File name you could recognize using for each loop and pass it to variable.RegardsViggneshwar A |
|
|
|
|
|
|
Expression to get the flatfile from the folder