Transform Data Task
-
I have a DTS package that has 7 Transform Data Tasks. One of the tasks does not seem to run sometimes. I never receive any errors for the package and I've investigated all areas that I can think of - everything comes up clean. I setup an exception file which never shows any errors and I also have an on failure workflow setup which never gives any errors. The task just doesn't seem to run. Any ideas?
-
What kind of workflow leads into the task that doesn't run? Try setting it to "on completion" and see if the task executes every time.
Greg
Greg
-
An on success workflow leads into it. The on success workflow leads into a connection which has two tasks. The two tasks then have two different destination connections. The connections are actually the same connection but they are separated out for whatever reason. The other task has never not completed.
-
Am I right in saying you've got two parallel transform data tasks: One is working, the other is not?What kind of connections are involved; are they Servers, Files (if so what type)?
-
Yes, two parallel connections. Both are SQL Server (Microsoft OLE DB Provider for SQL Server) connections. One works all the time the other works a majority of the time.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply