September 30, 2021 at 1:32 am
I'm trying to do a simple data copy from 1 server to another. I've done this in other .dtsx files and have had no problems. This .dtsx file was working, but when I went to run it again, I got an error I don't understand.
I'm running it task by task in by right clicking on the item in the control flow and choosing Execute Task.
The Prep task which truncates the old tables works great.
The Data flow task copies 2 tables from 2 different servers into the new location (on a single server). Each table is written completely (no missing records) The Progress shows no problems and looks identical to a run that works when I run it exactly the same way, but from a different .dtsx file.
What can cause the red X on the control flow task, but green checks on the data flow items?
September 30, 2021 at 1:58 am
I gave up and recreated the data flow component from scratch and it worked.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy