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 |
|
rira
Starting Member
3 Posts |
 Posted - 2008-12-02 : 01:34:19
|
| hi I have a MultipleFilesConnectionManager and I want to export the name of these files into a table as a column what should i do? thank u |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-02 : 01:55:30
|
| Use a data flow task with flat file as source and oledb as destination. map source to your file and destination to your sql table. |
 |
|
|
rira
Starting Member
3 Posts |
Posted - 2008-12-02 : 03:19:19
|
thank u for your answer but i want to have the name of these files in my table you know i have diffrent files with different names i want to access to these names and export them into table (as a new column ), during the contents of them export into the table  is it possible ?thank u Rira |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-02 : 03:26:26
|
| will filenames be in any specific format? |
|
|
|
rira
Starting Member
3 Posts |
Posted - 2008-12-02 : 03:36:18
|
| I have .txt files for example Employee.txt i want to export the 'Employee' as a string into a column of a table thank u Rira |
|
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2008-12-05 : 11:59:39
|
| Not sure if this might give some ideas [url]http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3405315&SiteID=17[/url] |
|
|
|
|
|
|
Export names of multiple files into a table