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 |
|
Horn300
Starting Member
8 Posts |
 Posted - 2013-01-31 : 07:31:13
|
| Hi,want to import csv-files and rename+move them to a subfolder "processed".Renaming and moving works fine, the data-flow-task does not.I contains a script-task to split columns and works fine and is proven outside the foreach-loop-container. I doesn't occure an error in the container and values displayed in data-viewer on incoming and outcoming side are o.k.But the target-table is not filled. Strange, isn't it?Thanks in advance for any help.Horn |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Horn300
Starting Member
8 Posts |
Posted - 2013-01-31 : 11:11:25
|
| Thanks for reply.Target connection type is OLE DB and static.Before data-flow there is a SQL-Task wich creates target-table in every loop new again (after drop).Data-flow has a script-task for transformation from 1 column in source to several columns in target.In debug-mode everything everything looks fine, transformation works properly.Here is a link to package[url]http://www.evernote.com/shard/s180/sh/6db7b87f-18c6-4cf1-b112-9184fda91e69/8e466aff5e3f85fbb7748f55df261d15[/url]With regardsHorn |
 |
|
|
Horn300
Starting Member
8 Posts |
Posted - 2013-01-31 : 11:25:55
|
| Sorry, found the mistake by myself.Transformation is o.k., there was wrong delete-statement in the following SQL-Task.Best regardsHorn |
|
|
|
|
|
|
Dataflow-Task doesn't work in foreach-loop-Contain