I am trying to design a package to import the data of several .tx files into a table in sql server.
1) I created an execute task that truncates the sql server table i.e. truncate table tblContacts
2)
Placed a forrloop container with enumerator: foreach file enumerator
Folder points to the folder that holds the txt files
file: *.*
filename: fully qualified
variablemapping: User::FileName with Index 0
3)
placed a data flow task inside the forloop
this dataflow task has the following dataflow:
FlatFile Source: connection manager is pointing to one of the txt files
OLE DB Destination to place the txt data into tblContact in the database.
The question:
when the package is run, the tblContact gets populated only from the first txt file, i.e. the one which I placed in the flatfilesource connection manager.
How can I allow several files in the flatfilesource, instead of the one I have now...
Thanks
Firstly, in your For Each Loop, you could change filter from *.* to *.tx (not essential)
You need to make the connectionstring variable (ConnectionString is a property of your FlatFile connection Manager )
Click on your FlatFile Connection Manager (this is at the bottom of the BIDS screen).
Go to the properties of the CM, I mean the properties window that appears on the right of your screen.
Expand the Expressions property collection, and drill through to get the Property Expressions editor.
Choose property ConnectionString, and drill through the expression to get the Expression Builder.
Drag your variable (FileName) and drop it into the Expression box. I assume the FileName variable contains the entire file path and name.
Now it should work fine.
没有评论:
发表评论