i encountered the timeout problem when using the SQLServer target in a dataflow.
details are described as following
1. an OLEDB source to read data
2. a Lookup component, here the Lookup table is set to table DIM_ACCOUNT
3. a SQLServer destination component, alse connected to same DIM_ACCOUNT table as previous component.
4. connect these components properly.
each time this dataflow was run, the SQLServer destination component issued a connection timeout error.
while i replaced the SQLServer destination with an OLEDB destination connected to exactly the same table, it worked.
what could be the problem?
i wish i could use the SQLServer destination , other than the OLEDB destination , as the former is much more efficient.
View Complete Post